On Nov 28, 2007 1:12 PM, Niels Nes Niels.Nes@cwi.nl wrote:
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'; replace PWD/filename.tbl with the server reachable location.
niels
Is there a sample tbl file somewhere? When the command I get the following:
copy 5 records into vendor_dim from '/tmp/vendor.csv' using delimiters '|', '|\n';
....contents of file like the following... !2456|'2456'|'FOO BAR CAFE'||'875 CENTER STREET RM'|'NY'|'NY'|' 96813'||||2456|2004-08-18||2004-08-19 !SQLException:importTable:failed to import table