Re: JSON to SQL

2016-01-28 Thread Andrés Ivaldi
gt; <http://www.amazon.com/Big-Data-Analytics-Spark-Practitioners/dp/1484209656/> > > > > *From:* Andrés Ivaldi [mailto:iaiva...@gmail.com] > *Sent:* Wednesday, January 27, 2016 7:17 PM > *To:* Cheng, Hao > *Cc:* Sahil Sareen; Al Pivonka; user > > *Subject:* Re: JS

RE: JSON to SQL

2016-01-28 Thread Mohammed Guller
day, January 27, 2016 7:17 PM To: Cheng, Hao Cc: Sahil Sareen; Al Pivonka; user Subject: Re: JSON to SQL I'm using DataFrames reading the JSON exactly as you say, and I can get the scheme from there. Reading the documentation, I realized that is possible to create Dynamically a Stru

RE: JSON to SQL

2016-01-27 Thread Cheng, Hao
“a.b[0].c” format of expression. From: Andrés Ivaldi [mailto:iaiva...@gmail.com] Sent: Thursday, January 28, 2016 3:39 AM To: Sahil Sareen Cc: Al Pivonka; user Subject: Re: JSON to SQL I'm really brand new with Scala, but if I'm defining a case class then is becouse I know how is the json's

Re: JSON to SQL

2016-01-27 Thread Andrés Ivaldi
/Hive/LanguageManual+LateralView, > as well as the “a.b[0].c” format of expression. > > > > > > *From:* Andrés Ivaldi [mailto:iaiva...@gmail.com] > *Sent:* Thursday, January 28, 2016 3:39 AM > *To:* Sahil Sareen > *Cc:* Al Pivonka; user > *Subject:* Re: JSON to S

Re: JSON to SQL

2016-01-27 Thread Al Pivonka
eld2444,555,,666,777,888 > > Right now this is what i need > > I will later add more intelligence, like detection of list or nested > objects and create relations in other tables. > > > > On Wed, Jan 27, 2016 at 11:25 AM, Al Pivonka <alpivo...@gmail.com> wr

Re: JSON to SQL

2016-01-27 Thread Andrés Ivaldi
, like detection of list or nested >> objects and create relations in other tables. >> >> >> >> On Wed, Jan 27, 2016 at 11:25 AM, Al Pivonka <alpivo...@gmail.com> wrote: >> >>> More detail is needed. >>> Can you provide some context to the u

Re: JSON to SQL

2016-01-27 Thread Sahil Sareen
>>> >>> I will later add more intelligence, like detection of list or nested >>> objects and create relations in other tables. >>> >>> >>> >>> On Wed, Jan 27, 2016 at 11:25 AM, Al Pivonka <alpivo...@gmail.com> >>>

Re: JSON to SQL

2016-01-27 Thread Andrés Ivaldi
ield 4,5,6,7,8 >>>> 11 22,33 Field144,55,66,77,88 >>>> 111 222,333 Field2444,555,,666,777,888 >>>> >>>> Right now this is what i need >>>> >>>> I will later add more inte

Re: JSON to SQL

2016-01-27 Thread Al Pivonka
More detail is needed. Can you provide some context to the use-case ? On Wed, Jan 27, 2016 at 8:33 AM, Andrés Ivaldi <iaiva...@gmail.com> wrote: > Hello, I'm trying to Save a JSON filo into SQL table. > > If i try to do this directly the IlligalArgumentException is rais

Re: JSON to SQL

2016-01-27 Thread Andrés Ivaldi
n of list or nested objects and create relations in other tables. On Wed, Jan 27, 2016 at 11:25 AM, Al Pivonka <alpivo...@gmail.com> wrote: > More detail is needed. > Can you provide some context to the use-case ? > > On Wed, Jan 27, 2016 at 8:33 AM, Andrés Ivaldi <ia

JSON to SQL

2016-01-27 Thread Andrés Ivaldi
Hello, I'm trying to Save a JSON filo into SQL table. If i try to do this directly the IlligalArgumentException is raised, I suppose this is beacouse JSON have a hierarchical structure, is that correct? If that is the problem, how can I flatten the JSON structure? The JSON structure