clickhouse-docs
clickhouse-docs copied to clipboard
Unknown setting format_schema_rows
(you don't have to strictly follow this form)
Describe the issue A clear and concise description of what's wrong in documentation.
try to run insert_values_with_expressions
, and build tables test_some_expr_matches
and test_all_expr_matches
by following the comment.
SELECT DOMInteractiveTiming, NSToDOMContentLoadedTiming, RefererCategories, URLCategories, arrayMap(x -> x * 0.5, RefererRegions) AS arf from test.hits LIMIT 10000 INTO OUTFILE '/path/to/data/user_files/test_some_expr_matches.values' FORMAT Template SETTINGS format_schema_rows = '(${DOMInteractiveTiming:Quoted} * ${NSToDOMContentLoadedTiming:Quoted}, arraySort(arrayConcat(${RefererCategories:Quoted}, ${URLCategories:Quoted})), arrayMap(x -> toString(x), ${arf:Quoted}))', format_schema_rows_between_delimiter = ',\n'
But got exception
Received exception from server (version 24.1.1):
Code: 115. DB::Exception: Received from localhost:9000. DB::Exception: Unknown setting format_schema_rows: Maybe you meant ['format_schema']. (UNKNOWN_SETTING)
Additional context Add any other context about the problem here.