Support Questions
Find answers, ask questions, and share your expertise
Announcements
Alert: Welcome to the Unified Cloudera Community. Former HCC members be sure to read and learn how to activate your account here.

can't access to array and struct items

Highlighted

can't access to array and struct items

New Contributor

Hi everyone,

 

I am using Hive to create a table for Json data.

The table contains an array column called items. Here is the first screenshot of the result of the column "items".

 

capture1.pngfirst screenshot

 

But when I want to access to an element of the array "items" (items[0] for example for the first element)

nothing shows up and the command of select still not showing anything for too long like this second screenshot.

 

capture2.pngsecond screenshot

 

i am facing this problem whatever it is an array or a struct column.

 

thanks,

Ines.