We're Moving!

The Vertica Forum is moving to a new OpenText Analytics Database (Vertica) Community.

Join us there to post discussion topics, learn about

product releases, share tips, access the blog, and much more.

Create My New Community Account Now


Load Gzip Data to flex table. — Vertica Forum

Load Gzip Data to flex table.

Naveen_KumarNaveen_Kumar
in General Discussion
Hi,
Can we directly load GaZIP data to flex table using fjson parser;?
as
Create flex table Flex_table();
Copy Flex_table from '/path/file.tar.gz' parser fjsonparser();
If i want to do it as, what should i have do?

Thanks
Regards
naveen

Comments

  • Naveen_KumarNaveen_Kumar
    I tried "Copy Flex_table from '/path/file.tar.gz' GZIP parser fjsonparser();"
    But it is giving an error like-
    "    ERROR 5861:  Error calling process() in User Function UDParser at [src/JSONParser.cpp:376], error code: 0, message: Unrecoverable parse exception while processing partition: [Unrecoverable YAJL Error on record # [0] with status: [parse error] and [1] Bytes consumed: [lexical error: invalid char in json text.                                       var/tellme/naveen/dum.txt                     (right here) ------^
    ]] while parsing JSON data for row [1] with [0] Bytes consumed."



Leave a Comment

BoldItalicStrikethroughOrdered listUnordered list
Format
SpoilerCodeQuote
Heading 2Heading 1
Emoji
:):D:(;):/:o:s:p:'(:|B):#:*<3o:)>:)
Url
Image
Align leftAlign centerAlign rightToggle HTML viewToggle full pageToggle lights
Drop image/file
Home • General DiscussionComment As ...