Support Questions
Find answers, ask questions, and share your expertise

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".


first screenshotfirst 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.


second screenshotsecond screenshot


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