You are viewing a plain text version of this content. The canonical link for it is here.

Posted to user@hive.apache.org by Andraz Tori <an...@zemanta.com> on 2010/06/30 17:26:59 UTC

using get_json_object with explode/lateral view

Hi,

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
parameter

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
www.zemanta.com
mail: andraz@zemanta.com
tel: +1 415 937 1 936       +386 41 515 767
twitter: andraz, skype: minmax_test