Skip to content

Cannot parse CSV with space delmiter. #6742

@akuzm

Description

@akuzm
$ 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.

Metadata

Metadata

Assignees

No one assigned

    Labels

    bugConfirmed user-visible misbehaviour in official releasecomp-formatsInput/output formats (CSV/JSON/Parquet/ORC/Arrow/Protobuf/etc.).usability

    Type

    No type

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions