The Vertica Forum recently got a makeover! Let us know what you think by filling out this short, anonymous survey.
Please take this survey to help us learn more about how you use third party tools. Your input is greatly appreciated!

Problem with FJSONParser

jsipekjsipek Vertica Customer

Hi, I am using copy local with FJSONParser to import data.
The problem is, when the JSON consists of escaped unicode letters like \u00e1 (in database stored as 0xDCC3], The import is mangled.
I tried to import the same file using Unix ODBC in Linux, in Windows via JDBC, Python in Linux, vsql directly on one of the nodes (locale set to en_US.UTF-8 on all nodes). I always get the same result. An ideas what may be wrong.
Thank You for help.

Answers

  • jsipekjsipek Vertica Customer

    Problem solved. The field was to short, therefore truncation occurred and data got mangled. Surprising was, that copy did not abort (ENFORCELENGTH ABORT ON ERROR).

Leave a Comment

BoldItalicStrikethroughOrdered listUnordered list
Emoji
Image
Align leftAlign centerAlign rightToggle HTML viewToggle full pageToggle lights
Drop image/file