You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
Parse CSV file error while import data from a CSV file.But the Clickhouse can parse successfully.
drop stream if exists test_csv;
create stream if not exists test_csv(
ip_range_start ipv4,
ip_range_end ipv4,
country_code nullable(string),
state1 nullable(string),
state2 nullable(string),
city nullable(string),
postcode nullable(string),
latitude float64,
longitude float64)
./proton-client -q "insert into test_csv format CSV" < ./dbip-city-ipv4.csv
Code: 27. DB::ParsingException: Cannot parse input: expected ',' at end of stream.: Buffer has gone, cannot extract information about what has been parsed.: While executing ParallelParsingBlockInputFormat: data for INSERT was parsed from stdin: (in query: insert into test_csv format CSV): (in file/uri (fd = 0)): (at row 2)
. (CANNOT_PARSE_INPUT_ASSERTION_FAILED)
'Hiroshima is the key to triggering the problem
The text was updated successfully, but these errors were encountered:
Parse CSV file error while import data from a CSV file.But the Clickhouse can parse successfully.
The CSV file :
./proton-client -q "insert into test_csv format CSV" < ./dbip-city-ipv4.csv
'Hiroshima
is the key to triggering the problemThe text was updated successfully, but these errors were encountered: