hive-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Connell, Chuck" <>
Subject json_tuple cannot parse array, correct?
Date Fri, 14 Sep 2012 21:50:37 GMT
(I tried this question to user@ but no one knew the answer...)

I am successfully using the json_tuple() function in Hive 0.8.1. It works fine. It appears
that there is no way to "drill down" into an array however. I want to confirm that I understand
this correctly.

So for the JSON object

{"text1":"hello", "array1":[4,5,6]}

I can retrieve the array as [4,5,6]. But I cannot extract any particular element.

Somewhat worse, for the object

{"array7" : [{"1":"one"} ,  {"2":"two"} , {"3":"three"}]}

I can retrieve the array as [{"1":"one"} ,  {"2":"two"} , {"3":"three"}], but I cannot extract
or parse any of the JSON objects in the array.


Thank you,
Chuck Connell

  • Unnamed multipart/alternative (inline, None, 0 bytes)
View raw message