On Nov 28, 2007 1:12 PM, Niels Nes
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