Raghav Kumar Gautam wrote:
Hi,
I am a new user and I am trying to bulk load a very largefile. The following is intended for testing only:
$ 7z e -so data.7z | head -n 100 | query "copy 100 RECORDS into data_table FROM STDIN USING DELIMITERS tuple_seperator '\r\n' record_seperator '\t';"
And am getting the following error: MAPI = rk@localhost:50000 QUERY = copy 100 RECORDS into data_table FROM STDIN USING DELIMITERS tuple_seperator '\r\n' record_seperator '\t'; ERROR = !syntax error, unexpected IDENT, expecting STRING in: "copy 100 records into data_table from stdin using delimiters tuple_seperator" Timer 0.278 msec
Can you tell me where am I going wrong ?
With Regards, Raghav.
You're using incorrect syntax for MonetDB. The copy command should be copy 100 records into data_table from stdin using delimiters '\r\n','\t'; And if you're using quotes around strings, you also have specify those: copy 100 records into data_table from stdin using delimiters '\r\n','\t','"'; -- Sjoerd Mullender