On Wed, Nov 28, 2007 at 12:02:18PM -0700, m h wrote:
Good afternoon-
Just wondering if there is a preferred method to load large datasets into monetdb? Piping SQL through mclient? copy into
some examples from 'tpch' COPY 5 RECORDS INTO region from 'PWD/region.tbl' USING DELIMITERS '|', '|\n'; COPY 25 RECORDS INTO nation from 'PWD/nation.tbl' USING DELIMITERS '|', '|\n'; COPY 10000 RECORDS INTO supplier from 'PWD/supplier.tbl' USING DELIMITERS '|', '|\n'; COPY 150000 RECORDS INTO customer from 'PWD/customer.tbl' USING DELIMITERS '|', '|\n'; COPY 200000 RECORDS INTO part from 'PWD/part.tbl' USING DELIMITERS '|', '|\n'; COPY 800000 RECORDS INTO partsupp from 'PWD/partsupp.tbl' USING DELIMITERS '|', '|\n'; COPY 1500000 RECORDS INTO orders from 'PWD/orders.tbl' USING DELIMITERS '|', '|\n'; COPY 7000000 RECORDS INTO lineitem from 'PWD/lineitem.tbl' USING DELIMITERS '|', '|\n'; replace PWD/filename.tbl with the server reachable location. niels
thanks much
-matt
------------------------------------------------------------------------- SF.Net email is sponsored by: The Future of Linux Business White Paper from Novell. From the desktop to the data center, Linux is going mainstream. Let it simplify your IT future. http://altfarm.mediaplex.com/ad/ck/8857-50307-18918-4 _______________________________________________ MonetDB-users mailing list MonetDB-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/monetdb-users
-- Niels Nes, Centre for Mathematics and Computer Science (CWI) Kruislaan 413, 1098 SJ Amsterdam, The Netherlands room C0.02, phone ++31 20 592-4098, fax ++31 20 592-4312 url: http://www.cwi.nl/~niels e-mail: Niels.Nes@cwi.nl