Re: hive json serde

2012-09-18 Thread Mark Golden
eld, $.C.D). If using a serde, then you can > say just C.D directly. > > ** ** > > Chuck Connell > > Nuance R&D Data Team > > Burlington, MA**** > > ** ** > > ** ** > > *From:* Mark Golden [mailto:mark.golden1...@gmail.com] > *Sent:* Mon

Re: hive json serde

2012-09-17 Thread Mark Golden
u want to use get_json_object, you don't need to load a SerDe. > > - With a SerDe, Hive understands JSON fields natively, so you can just use > the plain field names, no special function call at all. > > - I'm not sure if auxpath accepts a relative path, but I know the full > path works. > &g

Re: hive json serde

2012-09-17 Thread Mark Golden
2:54 PM, Mark Golden wrote: > :-) Thanks. I downloaded and got it compiled as well. > > My table has nested JSON values so when I tried to do > get_json_object(,'$.') this serde doesn't work in that case. > It throws an error. I'll email the developer too. >

Re: hive json serde

2012-09-17 Thread Mark Golden
ne. No problems found. The developer is also > quite responsive to issues raised. I encouraged him to submit it to the > Hive dev team as core code. > > ** ** > > https://github.com/rcongiu/Hive-JSON-Serde/ > > ** ** > > Chuck Connell > > Nuance R&

hive json serde

2012-09-17 Thread Mark Golden
Hi, I'm looking for a hive json serde that works well. Any suggestions? I did a quick google and found a few but none of them are complete. Thanks, Mark.