Grokbase Groups Hive user March 2011
FAQ
Hi All,

Iam using hive-0.7.0.
I want to use some like :

eg:
select a.timestamp, b.*
from log a lateral view json_tuple(a.appevent, 'eventid', 'eventname') b as f1,
f2;

For array elements in JSON.

So I tried something like json_tuple(a.appevent, 'arr[0].property1',
'arr[1].property1').

However it always returns NULL.

IS this supported? Or should I revert back and use get_json_object()?

Thanking you in advance.

Regards,
A.

Search Discussions

Related Discussions

Discussion Navigation
viewthread | post
Discussion Overview
groupuser @
categorieshive, hadoop
postedMar 12, '11 at 10:26a
activeMar 12, '11 at 10:26a
posts1
users1
websitehive.apache.org

1 user in discussion

A A: 1 post

People

Translate

site design / logo © 2022 Grokbase