Dear all,
I am trying to bulk load the TPC-DS database benchmark into MonetDB. One of the data file "customer.csv" contains data in this format:
27|AAAAAAAALBAAAAAA|111621|835|16096|2450611|2450581|Dr.|Shawn|Prather|N|7|3|1972|PUERTO RICO||Shawn.Prather@8BusRYegn6.org|2452353 28|AAAAAAAAMBAAAAAA|889961|897|183480|2452615|2452585|Miss|Edith|Hernandez|Y|17|8|1959|CÔTE D'IVOIRE||Edith.Hernandez@BNHL0k.com|2452631
Note in the second row, there is a string attribute containing a single quote.
And I use the below command to load it:
COPY INTO customer from 'path/to/customer.csv' USING DELIMITERS '|','\n' NULL AS '';
I have two machines with two installations:
one installed last year via Ubuntu apt-get, "monetdb version" shows "MonetDB Database Server Toolkit v1.1 (Jan2014-SP2)"
the other recently follows the instructions here: https://www.monetdb.org/downloads/deb/ (Ubuntu), "MonetDB Database Server Toolkit v1.1 (Jul2015)"
Somehow the loading succeeded in the former but failed in the latter. Is it due to some version difference? How can I fix it?
Error: field 15 expecting varchar(15) 'CÔTE D'IVOIRE'
Thanks in advance.
- Neo