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: [email protected] tel: +1 415 937 1 936 +386 41 515 767 twitter: andraz, skype: minmax_test
