clickhouse-docs icon indicating copy to clipboard operation
clickhouse-docs copied to clipboard

Unknown setting format_schema_rows

Open lgbo-ustc opened this issue 1 year ago • 0 comments

(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.

lgbo-ustc avatar Jan 19 '24 06:01 lgbo-ustc