JSON Failed to import

Sjoerd Mullender sjoerd at monetdb.org
Thu Apr 21 22:51:00 CEST 2016


This works:

301|{"data":[{"cdr_dialnumber":"6596871820"}]}

So the quoting of the json string doesn't help.

On 04/21/2016 09:26 PM, Ariel Abadi wrote:
> Hi!
> 
> Can someone help me ? Im trying to upload a CSV file with json data, but
> Im receiving an error. Does anybody has an idea how to solve this?
> 
> Thks in advance
> 
> mclient  -s"COPY 1 RECORDS INTO traf.jsontbl FROM STDIN  USING
>  DELIMITERS  '|','\n','\"' NULL AS 'null'" - < j.csv
> 
> *The data on j.csv is:*
> 301|"{\"data\":[{\"cdr_dialnumber\":\"6596871820\"}]}"
> 
> *TABLE  traf.xx
> *
> sql>\d jsontbl 
> CREATE TABLE "traf"."jsontbl" (
> "a" INTEGER,
> "b" JSON
> );
> 
> 
> 
> _______________________________________________
> users-list mailing list
> users-list at monetdb.org
> https://www.monetdb.org/mailman/listinfo/users-list
> 

-- 
Sjoerd Mullender

-------------- next part --------------
A non-text attachment was scrubbed...
Name: signature.asc
Type: application/pgp-signature
Size: 473 bytes
Desc: OpenPGP digital signature
URL: <http://www.monetdb.org/pipermail/users-list/attachments/20160421/6a9fb1a3/attachment.sig>


More information about the users-list mailing list