Importing data into singlestore db using csv

Help
#1

I am new to MEMSQL and trying to restore data into MEMSQL db using .csv file but its below error
ERROR 1017 ER_FILE_NOT_FOUND: Can’t find file: ‘\home\vagrant\filename.csv’ (errno: 2)

  1. CSV data is imported from another server.
  2. I have memsql on virtual machine.
  3. I have copied table dump csv to \home\vagrant\ location.
  4. I am trying below command to restore data.

LOAD DATA INFILE ‘\home\vagrant\filename.csv’ INTO TABLE “tableName” FIELDS TERMINATED BY ‘\t’ LINES TERMINATED BY ‘\n’;

Thanks in advance

#2

Hi - thank you for reaching out. Can you try adding LOCAL into your statement? For ex:

LOAD DATA LOCAL INFILE "\home\vagrant\filename.csv" INTO TABLE t FIELDS TERMINATED BY ‘\t’ LINES TERMINATED BY ‘\n’;

#3

Hey,
I have tried by adding LOCAL and now getting below error.
LOAD DATA local INFILE ‘\home\vagrant\filename.csv’ INTO TABLE t FIELDS TERMINATED BY ‘\t’ LINES TERMINATED BY ‘\n’

Local file data loading is not supported in SingleStore Studio

#4

Hi. You can’t run with “LOCAL INFILE” from SingleStore Studio because the browser can’t access the file system. Run your statement from DBeaver or the MySql CLI and it should work. - Best, Kevin

#5

hello,
SingleStore DB stores data almost blunders experienced amid each Stack Information operation, but the number of blunders is restricted to 1000 by default. When this constrain is come to, the stack comes up short. This anticipates out-of-memory issues when inadvertently stacking expansive records with off base organize or an off base Stack Information articulation. Utilize MAX_ERRORS at the conclusion of the explanation to alter this restrain. To indicate no restrain, set MAX_ERRORS to 0.

Writing to multiple databases in a transaction is not supported.

CSV LOAD DATA
Syntax

LOAD DATA [LOCAL] INFILE ‘<file_name>’
[REPLACE | IGNORE | SKIP { ALL | CONSTRAINT | DUPLICATE KEY | PARSER } ERRORS]
INTO TABLE <table_name>
[CHARACTER SET <character_set_name>]
[{FIELDS | COLUMNS}
[TERMINATED BY ‘’]
[[OPTIONALLY] ENCLOSED BY ‘’]
[ESCAPED BY ‘’]
]
[LINES
[STARTING BY ‘’]
[TERMINATED BY ‘’]
]
[TRAILING NULLCOLS]
[NULL DEFINED BY [OPTIONALLY ENCLOSED]]
[IGNORE LINES]
[ ({<column_name> | @<variable_name>}, …) ]
[SET <column_name> = ,…]
[WHERE ,…]
[MAX_ERRORS ]
[ERRORS HANDLE ]

#9

ERROR 1017 ER_FILE_NOT_FOUND: Can’t find file: ‘/home/ec2-user/Call_Data.csv’ (errno: 2)

Hi I Have using SingleStore offline version using centos server i have my csv at path: /home/ec2-user/
I have used FS as well as Infile but still getting this error, using local with infile doesnt help either below is script i am using

Create pipeline CalldataPipeline
AS
load data INFILE ‘/home/ec2-user/Call_Data.csv’
INTO table Calldata
FIELDS TERMINATED BY ‘,’ LINES TERMINATED BY ‘\r\n’;

Please Let me know what i am doing wrong