Here's how I was able to use LOAD DATA. First I ran into the issue of commas one field, in otherwise csv data. So, I edited the data file with vi and changed all the delimiters to the '|' symbol using this vi command. :1,$ s/","/"|"/g Then using SQL for the create table, CREATE TABLE scotch_reviews ( name VARCHAR(255), category VARCHAR(255), review_point INT, price DOUBLE, description VARCHAR(2000), description_vector VECTOR(DOUBLE, 384)) Then using LOAD DATA: LOAD BULK DATA FROM FILE 'scotch_reviews.tbl' INTO scotch_reviews (name, category, review_point, price, description) USING '{ "from": {"file": {"columnseparator":"|"} } }' And it worked.
Here's how I was able to use LOAD DATA. First I ran into the issue of commas one field, in otherwise csv data.
So, I edited the data file with vi and changed all the delimiters to the '|' symbol using this vi command. :1,$ s/","/"|"/g
Then using SQL for the create table,
CREATE TABLE scotch_reviews ( name VARCHAR(255),
category VARCHAR(255),
review_point INT,
price DOUBLE,
description VARCHAR(2000),
description_vector VECTOR(DOUBLE, 384))
Then using LOAD DATA:
LOAD BULK DATA FROM FILE 'scotch_reviews.tbl'
INTO scotch_reviews (name, category, review_point, price, description)
USING '{ "from": {"file": {"columnseparator":"|"} } }'
And it worked.