Re: Cant join same dataframe twice ?

2016-04-27 Thread Divya Gehlot
lysisException: Reference 'b' is >>>> ambiguous, could be: b#6, b#14.; >>>> If same case, this message makes sense and this is clear. >>>> >>>> Thought? >>>> >>>> // maropu >>>> >>>> >>>> &

Re: Cant join same dataframe twice ?

2016-04-27 Thread Ted Yu
>>> >>> And I got; org.apache.spark.sql.AnalysisException: Reference 'b' is >>> ambiguous, could be: b#6, b#14.; >>> If same case, this message makes sense and this is clear. >>> >>> Thought? >>> >>> // maropu >>> >

Re: Cant join same dataframe twice ?

2016-04-26 Thread Takeshi Yamamuro
ear. >> >> Thought? >> >> // maropu >> >> >> >> >> >> >> >> On Wed, Apr 27, 2016 at 6:09 AM, Prasad Ravilla <pras...@slalom.com> >> wrote: >> >>> Also, check the column names of df1 ( after joining df2

Re: Cant join same dataframe twice ?

2016-04-26 Thread Divya Gehlot
d this is clear. > > Thought? > > // maropu > > > > > > > > On Wed, Apr 27, 2016 at 6:09 AM, Prasad Ravilla <pras...@slalom.com> > wrote: > >> Also, check the column names of df1 ( after joining df2 and df3 ). >> >> Prasad. >>

Re: Cant join same dataframe twice ?

2016-04-26 Thread Takeshi Yamamuro
d be: b#6, b#14.; >> If same case, this message makes sense and this is clear. >> >> Thought? >> >> // maropu >> >> >> >> >> >> >> >> On Wed, Apr 27, 2016 at 6:09 AM, Prasad Ravilla <pras...@slalom.com> >&g

Re: Cant join same dataframe twice ?

2016-04-26 Thread Ted Yu
> > wrote: > >> Also, check the column names of df1 ( after joining df2 and df3 ). >> >> Prasad. >> >> From: Ted Yu >> Date: Monday, April 25, 2016 at 8:35 PM >> To: Divya Gehlot >> Cc: "user @spark" >> Subject: Re: Cant join

Re: Cant join same dataframe twice ?

2016-04-26 Thread Takeshi Yamamuro
sad. > > From: Ted Yu > Date: Monday, April 25, 2016 at 8:35 PM > To: Divya Gehlot > Cc: "user @spark" > Subject: Re: Cant join same dataframe twice ? > > Can you show us the structure of df2 and df3 ? > > Thanks > > On Mon, Apr 25, 2016 at 8:23 PM, Divya

Re: Cant join same dataframe twice ?

2016-04-26 Thread Prasad Ravilla
Also, check the column names of df1 ( after joining df2 and df3 ). Prasad. From: Ted Yu Date: Monday, April 25, 2016 at 8:35 PM To: Divya Gehlot Cc: "user @spark" Subject: Re: Cant join same dataframe twice ? Can you show us the structure of df2 and df3 ? Thanks On Mon, Apr 25, 20

Re: Cant join same dataframe twice ?

2016-04-25 Thread Ted Yu
Can you show us the structure of df2 and df3 ? Thanks On Mon, Apr 25, 2016 at 8:23 PM, Divya Gehlot wrote: > Hi, > I am using Spark 1.5.2 . > I have a use case where I need to join the same dataframe twice on two > different columns. > I am getting error missing