go to post Mark Morris · Jun 27 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/","/"|"/gThen 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.