Please take this survey to help us learn more about how you use third party tools. Your input is greatly appreciated!

Result of Array differs from xyztable to xyztable_view (flex zone, array)

Hello,

I've tried to load a JSON in Vertica via FlexZone without "flatten_arrays" and I'm confused about the result I get when I query arrays:

In this case, twitter hash tags are listed as arrays in a JSON fileas follows:
"interaction": {
"hashtags": [
            "Snowden",
       "NSA",
       "Cookies"
   ],
   ** further keys **

 

 

When I query them, I within the "normal" flex table, I get a result that's readable (snippet 1; even if the structure isn't perfect). However, after the creation of the view, (build_flextable_view) the query shows a very unstructured non-readable result (snippet 2).

 

My question: Do you know why?

 

SNIPPET 1:

 

MyFirstDatabase=> select "interaction.hashtags" from datasift4;

interaction.hashtags           
--------------------------------------------
  ! SnowdenNSACookies 012
  spiegel0
  * 'JanukowitschNachrichtenN24 012
focus0
  & #FußballNachrichtenN24 012
#)KlimaMittelerdeMordorTexas 0123
  ' $NordkoreaNachrichtenN24 012
4News
  # FristNachrichtenN24 012
  $ !GroßeNachrichtenN24 012

(22 rows) ** (comment: not all rows necessary to explain my problem)

 

SNIPPET 2 (extract):

MyFirstDatabase=> select "interaction.hashtags" from datasift4_view;             

interaction.hashtags
--------------------------------------------------------------------
\001\000\000\000!\000\000\000\003\000\000\000\020\000\000\000\027\000\000\000\032\000\000\000SnowdenNSACookies\003\000\000\000\020\000\000\000\021\000\000\000\022\000\000\000012
\001\000\000\000\017\000\000\000\001\000\000\000\010\000\000\000spiegel\001\000\000\000\010\000\000\0000
 \001\000\000\000*\000\000\000\003\000\000\000\020\000\000\000\034\000\000\000'\000\000\000JanukowitschNachrichtenN24\003\000\000\000\020\000\000\000\021\000\000\000\022\000\000\000012

 

 

 

 Thank you!

Leave a Comment

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

Can't find what you're looking for? Search the Vertica Documentation, Knowledge Base, or Blog for more information.