Hi Raghav, "tuple_seperator" & "record_seperator" are no SQL key words, but merely place holders for the tuples separator and tuple separator, respectively, in the EBNF (Extended Backus–Naur Form; cf. e.g., http://en.wikipedia.org/wiki/Extended_Backus–Naur_Form) of the SQL-2003 syntax description. Hence, your query should rather look as follows: copy 100 RECORDS into data_table FROM STDIN USING DELIMITERS '\r\n', '\t'; Stefan On Fri, Dec 11, 2009 at 10:40:00PM -0800, 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.
------------------------------------------------------------------------------ Return on Information: Google Enterprise Search pays you back Get the facts. http://p.sf.net/sfu/google-dev2dev _______________________________________________ MonetDB-users mailing list MonetDB-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/monetdb-users
-- | Dr. Stefan Manegold | mailto:Stefan.Manegold@cwi.nl | | CWI, P.O.Box 94079 | http://www.cwi.nl/~manegold/ | | 1090 GB Amsterdam | Tel.: +31 (20) 592-4212 | | The Netherlands | Fax : +31 (20) 592-4199 |