Hi, I am new to memsql and trying to import local csv from Windows computer using memsql studio.
My setup:
- Spun up a test cluster on AWS with 1 master node and 1 leaf node using the default cloudformation template.
- Have a local CSV on my windows computer and tried importing to a table on the cluster.
Tried the following and getting file not found error for csv(which kind of make sense because it is a local file).
LOAD DATA INFILE ‘C:/temp/brentwood_p01_nogeom.csv’
INTO TABLE brentwood_p01_nogeom
COLUMNS TERMINATED BY ‘,’;
LOAD DATA INFILE ‘C:\temp\brentwood_p01_nogeom.csv’
INTO TABLE brentwood_p01_nogeom
COLUMNS TERMINATED BY ‘,’;
-
Tried this and getting a message that LOCAL file is not supported on memsql studio.
LOAD DATA LOCAL INFILE ‘C:/temp/brentwood_p01_nogeom.csv’
INTO TABLE brentwood_p01_nogeom
COLUMNS TERMINATED BY ‘,’; -
Copied the file onto the master node and tried the following command. Still getting file not found error.
LOAD DATA INFILE ‘/tmp/brentwood_p01_nogeom.csv’
INTO TABLE brentwood_p01_nogeom
COLUMNS TERMINATED BY ‘,’;
I am missing something very trivial. Any suggestions to make it work?
Thanks!