Re: Unable to join table across data sources using sparkSQL

2015-05-08 Thread Ishwardeep Singh
was in printSchema() output. printSchema() output for data frame created using hive driver prefixes the column names with table name but the same does not happen for terradata tables. -- View this message in context: http://apache-spark-user-list.1001560.n3.nabble.com/Unable-to-join-table-across-data

Re: Unable to join table across data sources using sparkSQL

2015-05-05 Thread ayan guha
) Regards, Ishwardeep *From:* ankitjindal [via Apache Spark User List] [mailto:ml-node+[hidden email] http:///user/SendEmail.jtp?type=nodenode=22768i=0] *Sent:* Tuesday, May 5, 2015 5:00 PM *To:* Ishwardeep Singh *Subject:* RE: Unable to join table across data sources using sparkSQL

RE: Unable to join table across data sources using sparkSQL

2015-05-05 Thread Ishwardeep Singh
, Ishwardeep From: ankitjindal [via Apache Spark User List] [mailto:ml-node+s1001560n22766...@n3.nabble.com] Sent: Tuesday, May 5, 2015 5:00 PM To: Ishwardeep Singh Subject: RE: Unable to join table across data sources using sparkSQL Just check the Schema of both the tables using frame.printSchema

RE: Unable to join table across data sources using sparkSQL

2015-05-05 Thread Ishwardeep Singh
User List] [mailto:ml-node+s1001560n22762...@n3.nabble.com] Sent: Tuesday, May 5, 2015 1:26 PM To: Ishwardeep Singh Subject: Re: Unable to join table across data sources using sparkSQL Hi I was doing the same but with a file in hadoop as a temp table and one table in sql server but i succeeded