Load Gzip Data to flex table.

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

  • 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
Emoji
Image
Align leftAlign centerAlign rightToggle HTML viewToggle full pageToggle lights
Drop image/file