Re: nested JSON structures

2011-12-09 Thread Roberto Congiu
I wrote a SerDe that can handle nested structures. https://github.com/rcongiu Roberto On Fri, Dec 9, 2011 at 7:42 AM, Ibrahim Acet wrote: > Hi, > > are there any tutorials available for custom UDF creation ? > > ** ** > > thx > > ** ** > > *Von:* Edward Capriolo [mailto:edlinuxg..

AW: nested JSON structures

2011-12-09 Thread Ibrahim Acet
Hi, are there any tutorials available for custom UDF creation ? thx Von: Edward Capriolo [mailto:edlinuxg...@gmail.com] Gesendet: Freitag, 9. Dezember 2011 16:22 An: user@hive.apache.org Betreff: Re: nested JSON structures Hive does have some JSON capabilities. To handle nested structures

Re: nested JSON structures

2011-12-09 Thread Edward Capriolo
Hive does have some JSON capabilities. To handle nested structures like this I have wrtten custom UDFs that return structs and then use LATERAL VIEW and explode on them. http://www.slideshare.net/edwardcapriolo/breaking-firstnormal-form-with-hive On Fri, Dec 9, 2011 at 10:06 AM, Ibrahim Acet wro

AW: nested JSON structures

2011-12-09 Thread Ibrahim Acet
Hi, with nested json I mean something like this: {"success": "true", "message": "", "total": "1", "data": { "id": "0001", "type": "donut", "name": "Cake", "ppu": 0.55, "batters": { "batter":

Re: Loading data into hive tables

2011-12-09 Thread alo alt
u welcome :) On Fri, Dec 9, 2011 at 9:44 AM, Aditya Singh30 wrote: > Thanks a lot. It is the very thing I was looking for.. J > > ** ** > > *From:* alo alt [mailto:wget.n...@googlemail.com] > *Sent:* Friday, December 09, 2011 1:27 PM > *To:* user@hive.apache.org; bejoy...@yahoo.com > *Subject

RE: Loading data into hive tables

2011-12-09 Thread Aditya Singh30
Thanks a lot. It is the very thing I was looking for.. :) From: alo alt [mailto:wget.n...@googlemail.com] Sent: Friday, December 09, 2011 1:27 PM To: user@hive.apache.org; bejoy...@yahoo.com Subject: Re: Loading data into hive tables Adithya, Here small articles about: MS SQL => Sqoop http://map