-
Notifications
You must be signed in to change notification settings - Fork 8.3k
Cannot parse CSV with space delmiter. #6742
Copy link
Copy link
Closed
Labels
bugConfirmed user-visible misbehaviour in official releaseConfirmed user-visible misbehaviour in official releasecomp-formatsInput/output formats (CSV/JSON/Parquet/ORC/Arrow/Protobuf/etc.).Input/output formats (CSV/JSON/Parquet/ORC/Arrow/Protobuf/etc.).usability
Description
$ 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 before could use some quoting.
Reactions are currently unavailable
Metadata
Metadata
Assignees
Labels
bugConfirmed user-visible misbehaviour in official releaseConfirmed user-visible misbehaviour in official releasecomp-formatsInput/output formats (CSV/JSON/Parquet/ORC/Arrow/Protobuf/etc.).Input/output formats (CSV/JSON/Parquet/ORC/Arrow/Protobuf/etc.).usability