(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. Correct?? Thank you, Chuck Connell