Roberto Congiu

for a while that option was not available..and now I built scripts to automatically build and deploy versions for every version. It looks to me like a lot of clicking...

That's not how the SerDe works. You can declare your table as a normal table without the json serde if you want to use get_json_object. If you want to use...

In the current architecture, the json object is parsed, and in this case, 'ctx' is mapped to a JSON Object, which is normally read by a JSON Struct Object Inspector....

I see, the issue is that your record is actually an array. In hive a record has to be a struct.

I see... I was about to tell you to try with views, but it's not that easy since you want to pick something in the array. There are 2 ways...

I can't quite remember but I think the versions of hive/hadoop for HDP2.4 are the same.

Sorry I didn't see the message. You mean the whole serde ? Sure, I'd be happy to. Should I change the java package ?

create table x ( a array ) will work fine with your example

'Create table x (a array )'

Sorry on cell phone.. can't find bacticks on this keyboard