Unsupported syntax: LOAD DATA ... IGNORE 1 ROWS

[Vectorial1024]

This does not seem obvious to me, but how do I import or upload data from csv files?

I have read from here https://www.dolthub.com/blog/2020-02-03-dolt-and-dolthub-getting-started/ about how to export data into csv, but I am stuck tring to import data from csv. While exploring how to import data from csv into dolt tables, I came across the blog here https://www.dolthub.com/blog/2020-02-03-dolt-and-dolthub-getting-started/

I tried the following:

dolt sql
db> LOAD DATA INFILE "./data.csv" INTO TABLE estate FIELDS TERMINATED BY ',' ENCLOSED BY '' LINES TERMINATED BY '\n' IGNORE 1 ROWS;

But it always complain about SQL syntax errors:

syntax error at position [...] near 'ROWS'
[...] IGNORE 1 ROWS;
                    ^

Help is appreciated, thanks!

[Vectorial1024]

Update: turns out this question is already answered by the blog here https://www.dolthub.com/blog/2020-04-29-dolt-dolthub-publish-csv/ . My bad for not exploring the existing documentations well enough.

Still, leaving this open in case the above error is needed to be fixed.

[VinaiRachakonda]

@Vectorial1024 You have found a bug in our parsing of LOAD DATA queries. If you switch ROWS to LINES it should work as intended.

dolt table import is easiest way to get data into dolt