$ echo "1 2" | clickhouse-local -S "a int, b int" --input-format="CSV" --format_csv_delimiter=' ' -q "select * from table"
Code: 27, e.displayText() = DB::Exception: Cannot parse input: expected before: 2\n: (at row 1)
Row 1:
Column 0, name: a, type: Int32, parsed text: "1"
ERROR: There is no delimiter ( ). "2" found instead.
(version 19.13.1.1)
Also, the
expected beforecould use some quoting.