Grokbase Groups Hive user June 2010

I am trying to explode or lateral view on a list that is returned by
get_jsonb_object, something along these lines:

select explode(get_json_object(jsonblob, '$.output_dict.articles.url'))
as url from sometable;

I get:
FAILED: Error in semantic analysis: explode() takes an array as a

The trick is that what get_json_object returns is an array (or is it a
string representation of an array?)

a) how to do it?

b) any chance for explode to produce enumeration too (so I'd get two
variables out of each entry - url and position)

Andraz Tori, CTO
Zemanta Ltd, New York, London, Ljubljana
tel: +1 415 937 1 936 +386 41 515 767
twitter: andraz, skype: minmax_test

Search Discussions

Discussion Posts

Follow ups

Related Discussions

Discussion Navigation
viewthread | post
posts ‹ prev | 1 of 3 | next ›
Discussion Overview
groupuser @
categorieshive, hadoop
postedJun 30, '10 at 3:57p
activeJun 30, '10 at 6:17p

2 users in discussion

Andraz Tori: 2 posts Paul Yang: 1 post



site design / logo © 2021 Grokbase