Suppose I would like to import a csv file into the following table:
CREATE TABLE example_table (
id int PRIMARY KEY,
comma_delimited_str_list list<ascii>,
space_delimited_str_list list<ascii>
);
where comma_delimited_str_list and space_delimited_str_list are two list-attributes which use comma and space as their delimiter respectively.
An example csv record would be:
12345,"hello,world","stack overflow"
where I would like to treat "hello,world" and "stack overflow" as two multi-valued attributes.
Can I know how to import such CSV file into its corresponding table in Cassandra? Preferably using CQL COPY?
