linux - How to use sqlite command to import large CSV file?

Question

The problem is that the node that runs this needs more RAM than I have. The size of the final table should be around ~300GB.

sqlite>.import data.csv myTable

sqlite> CREATE TABLE DX (
                   id INTEGER,
                   data1 TEXT,
                   data2 INTEGER,
                   ...
                  );

标签： linuxsqlitecsvimport

Answer 1

正如肖恩所说，您只需使用：

.open filename

这会在磁盘上创建数据库，这就是您导入时数据所在的位置。