On Nov 28, 2007 1:49 PM, Niels Nes
On Wed, Nov 28, 2007 at 01:45:44PM -0700, m h wrote:
Whoops forgot one bit of the error....
Is there a sample tbl file somewhere? When I run the command I get IN the sources sql/src/benchmark/tpch/SF-0.01/ the following:
copy 5 records into vendor_dim from '/tmp/vendor.csv' using delimiters '|', '|\n';
!SQLException:sql:decimal wrong format ....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 ^
Which of these is supposed to be a decimal?
Everything that looks like an INT is actually a NUMERIC (sorry, I'm trying to keep the same schema as the original.... )
(quotes are only needed in case the strings aren't safe, ie when they contain the seperator.
I you use the two given seperators (field and record) then at the end you need '|\n' or change the seperator into '\n'.
Thanks I changed this, am still getting the error. The data is confidential, let me try to create some non-confidential example....