Grokbase Groups Hive user June 2010
FAQ
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

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
posts3
users2
websitehive.apache.org

2 users in discussion

Andraz Tori: 2 posts Paul Yang: 1 post

People

Translate

site design / logo © 2021 Grokbase