You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user@spark.apache.org by Ishwardeep Singh <is...@impetus.co.in> on 2015/05/05 09:20:12 UTC

Unable to join table across data sources using sparkSQL

Hi ,

I am trying to use sparkSQL to join tables in different data sources - hive
and teradata. I can access the tables individually but when I run join query
I get an query exception. 

The same query runs if all the tables exist in teradata. 

Any help would be appreciated.

I am running the following commands using spark-shell (spark version 1.3.0)

val hc = new org.apache.spark.sql.hive.HiveContext(sc)
val hiveStoreSalesDF=
hc.load("jdbc",Map("url"->"jdbc:hive2://192.168.145.39:10000/benchqads_teradata?user=hive&password=***","dbtable"
-> "store_sales"))
hiveStoreSalesDF.registerTempTable("store_sales")

val dateDimDF=
hc.load("jdbc",Map("url"->"jdbc:teradata://192.168.145.58/DBS_PORT=1025,DATABASE=BENCHQADS,LOB_SUPPORT=OFF,USER=
BENCHQADS,PASSWORD=****","dbtable" -> "date_dim"))
dateDimDF.registerTempTable("date_dim")

val itemDF=
hc.load("jdbc",Map("url"->"jdbc:teradata://192.168.145.58/DBS_PORT=1025,DATABASE=BENCHQADS,LOB_SUPPORT=OFF,USER=
BENCHQADS,PASSWORD=****","dbtable" -> "item"))
itemDF.registerTempTable("item")

val report = hc.sql("select d_year, item.i_brand_id brand_id, item.i_brand
brand from date_dim, store_sales, item where  date_dim.d_date_sk =
store_sales.ss_sold_date_sk and store_sales.ss_item_sk = item.i_item_sk and
item.i_manufact_id = 922 and date_dim.d_moy=12 group by d_year ,item.i_brand
,item.i_brand_id order by d_year desc,brand_id")

org.apache.spark.sql.AnalysisException: cannot resolve 'd_year' given input
columns store_sales.ss_item_sk, d_following_holiday,
store_sales.ss_sales_price, i_class_id, d_date_id, d_fy_year,
i_wholesale_cost, store_sales.ss_store_sk, store_sales.ss_net_paid,
d_day_name, d_week_seq, d_quarter_name, d_current_quarter, i_rec_end_date,
i_class, store_sales.ss_sold_date_sk, d_fy_quarter_seq,
store_sales.ss_ext_tax, d_moy, d_first_dom, i_current_price, i_brand,
i_brand_id, d_qoy, store_sales.ss_list_price, i_container,
store_sales.ss_ext_sales_price, store_sales.ss_wholesale_cost, d_dom,
d_current_year, d_current_week, i_item_desc,
store_sales.ss_ext_wholesale_cost, store_sales.ss_cdemo_sk,
i_rec_start_date, d_last_dom, d_dow, store_sales.ss_promo_sk, i_category_id,
i_color, i_units, d_date_sk, store_sales.ss_ticket_number, i_item_sk,
store_sales.ss_coupon_amt, store_sales.ss_quantity, d_same_day_lq,
store_sales.ss_net_paid_inc_tax, d_date, d_weekend, d_current_month,
store_sales.ss_ext_discount_amt, d_current_day, store_sales.ss_hdemo_sk,
d_year, i_category, d_month_seq, i_manufact_id, store_sales.ss_net_profit,
store_sales.ss_addr_sk, store_sales.ss_customer_sk, d_same_day_ly,
d_quarter_seq, d_holiday, i_size, store_sales.ss_ext_list_price,
i_formulation, i_manager_id, i_manufact, d_fy_week_seq, i_product_name,
store_sales.ss_sold_time_sk, i_item_id; line 1 pos 253

Regards,
Ishwardeep






--
View this message in context: http://apache-spark-user-list.1001560.n3.nabble.com/Unable-to-join-table-across-data-sources-using-sparkSQL-tp22761.html
Sent from the Apache Spark User List mailing list archive at Nabble.com.

---------------------------------------------------------------------
To unsubscribe, e-mail: user-unsubscribe@spark.apache.org
For additional commands, e-mail: user-help@spark.apache.org


Re: Unable to join table across data sources using sparkSQL

Posted by Ishwardeep Singh <is...@impetus.co.in>.
Finally got it working.

I was trying to access hive using the jdbc driver like I was trying to
access the terradata. 

It took me some time to figure out that default sqlContext created by Spark
supported hive and it uses the hive-site.xml in spark conf folder to access
hive.

I had to use my database in hive.

spark-shell> sqlContext.sql("use terradata_live")

Then I registered by terradata database tables as temporary tables.

spark-shell>  val itemDF=
hc.load("jdbc",Map("url"->"jdbc:teradata://192.168.145.58/DBS_PORT=1025,DATABASE=BENCHQADS,LOB_SUPPORT=OFF,USER=
BENCHQADS,PASSWORD=****","dbtable" -> "item")) 

spark-shell> itemDF.registerTempTable("itemterra")

spark-shell> sqlContext.sql("select store_sales.* from store_sales join
itemterra on (store_sales.id = itemterra.sales_id)

But these seems to be some issue when I try to do the same using hive jdbc
driver. Another difference that I found 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-sources-using-sparkSQL-tp22761p22816.html
Sent from the Apache Spark User List mailing list archive at Nabble.com.

---------------------------------------------------------------------
To unsubscribe, e-mail: user-unsubscribe@spark.apache.org
For additional commands, e-mail: user-help@spark.apache.org


Re: Unable to join table across data sources using sparkSQL

Posted by ayan guha <gu...@gmail.com>.
The error shows d_year column does not exist. You may need to modify the
query.
On 5 May 2015 17:20, "Ishwardeep Singh" <is...@impetus.co.in>
wrote:

> Hi ,
>
> I am trying to use sparkSQL to join tables in different data sources - hive
> and teradata. I can access the tables individually but when I run join
> query
> I get an query exception.
>
> The same query runs if all the tables exist in teradata.
>
> Any help would be appreciated.
>
> I am running the following commands using spark-shell (spark version 1.3.0)
>
> val hc = new org.apache.spark.sql.hive.HiveContext(sc)
> val hiveStoreSalesDF=
> hc.load("jdbc",Map("url"->"jdbc:hive2://
> 192.168.145.39:10000/benchqads_teradata?user=hive&password=***","dbtable"
> -> "store_sales"))
> hiveStoreSalesDF.registerTempTable("store_sales")
>
> val dateDimDF=
> hc.load("jdbc",Map("url"->"jdbc:teradata://
> 192.168.145.58/DBS_PORT=1025,DATABASE=BENCHQADS,LOB_SUPPORT=OFF,USER=
> BENCHQADS,PASSWORD=****","dbtable" -> "date_dim"))
> dateDimDF.registerTempTable("date_dim")
>
> val itemDF=
> hc.load("jdbc",Map("url"->"jdbc:teradata://
> 192.168.145.58/DBS_PORT=1025,DATABASE=BENCHQADS,LOB_SUPPORT=OFF,USER=
> BENCHQADS,PASSWORD=****","dbtable" -> "item"))
> itemDF.registerTempTable("item")
>
> val report = hc.sql("select d_year, item.i_brand_id brand_id, item.i_brand
> brand from date_dim, store_sales, item where  date_dim.d_date_sk =
> store_sales.ss_sold_date_sk and store_sales.ss_item_sk = item.i_item_sk and
> item.i_manufact_id = 922 and date_dim.d_moy=12 group by d_year
> ,item.i_brand
> ,item.i_brand_id order by d_year desc,brand_id")
>
> org.apache.spark.sql.AnalysisException: cannot resolve 'd_year' given input
> columns store_sales.ss_item_sk, d_following_holiday,
> store_sales.ss_sales_price, i_class_id, d_date_id, d_fy_year,
> i_wholesale_cost, store_sales.ss_store_sk, store_sales.ss_net_paid,
> d_day_name, d_week_seq, d_quarter_name, d_current_quarter, i_rec_end_date,
> i_class, store_sales.ss_sold_date_sk, d_fy_quarter_seq,
> store_sales.ss_ext_tax, d_moy, d_first_dom, i_current_price, i_brand,
> i_brand_id, d_qoy, store_sales.ss_list_price, i_container,
> store_sales.ss_ext_sales_price, store_sales.ss_wholesale_cost, d_dom,
> d_current_year, d_current_week, i_item_desc,
> store_sales.ss_ext_wholesale_cost, store_sales.ss_cdemo_sk,
> i_rec_start_date, d_last_dom, d_dow, store_sales.ss_promo_sk,
> i_category_id,
> i_color, i_units, d_date_sk, store_sales.ss_ticket_number, i_item_sk,
> store_sales.ss_coupon_amt, store_sales.ss_quantity, d_same_day_lq,
> store_sales.ss_net_paid_inc_tax, d_date, d_weekend, d_current_month,
> store_sales.ss_ext_discount_amt, d_current_day, store_sales.ss_hdemo_sk,
> d_year, i_category, d_month_seq, i_manufact_id, store_sales.ss_net_profit,
> store_sales.ss_addr_sk, store_sales.ss_customer_sk, d_same_day_ly,
> d_quarter_seq, d_holiday, i_size, store_sales.ss_ext_list_price,
> i_formulation, i_manager_id, i_manufact, d_fy_week_seq, i_product_name,
> store_sales.ss_sold_time_sk, i_item_id; line 1 pos 253
>
> Regards,
> Ishwardeep
>
>
>
>
>
>
> --
> View this message in context:
> http://apache-spark-user-list.1001560.n3.nabble.com/Unable-to-join-table-across-data-sources-using-sparkSQL-tp22761.html
> Sent from the Apache Spark User List mailing list archive at Nabble.com.
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: user-unsubscribe@spark.apache.org
> For additional commands, e-mail: user-help@spark.apache.org
>
>

Re: Unable to join table across data sources using sparkSQL

Posted by ayan guha <gu...@gmail.com>.
I suggest you to try with date_dim.d_year in the query

On Tue, May 5, 2015 at 10:47 PM, Ishwardeep Singh <
ishwardeep.singh@impetus.co.in> wrote:

>  Hi Ankit,
>
>
>
> printSchema() works fine for all the tables.
>
>
>
> hiveStoreSalesDF.printSchema()
>
> root
>
> |-- store_sales.ss_sold_date_sk: integer (nullable = true)
>
> |-- store_sales.ss_sold_time_sk: integer (nullable = true)
>
> |-- store_sales.ss_item_sk: integer (nullable = true)
>
> |-- store_sales.ss_customer_sk: integer (nullable = true)
>
> |-- store_sales.ss_cdemo_sk: integer (nullable = true)
>
> |-- store_sales.ss_hdemo_sk: integer (nullable = true)
>
> |-- store_sales.ss_addr_sk: integer (nullable = true)
>
> |-- store_sales.ss_store_sk: integer (nullable = true)
>
> |-- store_sales.ss_promo_sk: integer (nullable = true)
>
> |-- store_sales.ss_ticket_number: integer (nullable = true)
>
> |-- store_sales.ss_quantity: integer (nullable = true)
>
> |-- store_sales.ss_wholesale_cost: double (nullable = true)
>
> |-- store_sales.ss_list_price: double (nullable = true)
>
> |-- store_sales.ss_sales_price: double (nullable = true)
>
> |-- store_sales.ss_ext_discount_amt: double (nullable = true)
>
> |-- store_sales.ss_ext_sales_price: double (nullable = true)
>
> |-- store_sales.ss_ext_wholesale_cost: double (nullable = true)
>
> |-- store_sales.ss_ext_list_price: double (nullable = true)
>
> |-- store_sales.ss_ext_tax: double (nullable = true)
>
> |-- store_sales.ss_coupon_amt: double (nullable = true)
>
> |-- store_sales.ss_net_paid: double (nullable = true)
>
> |-- store_sales.ss_net_paid_inc_tax: double (nullable = true)
>
> |-- store_sales.ss_net_profit: double (nullable = true)
>
>
>
> dateDimDF.printSchema()
>
> root
>
> |-- d_date_sk: integer (nullable = false)
>
> |-- d_date_id: string (nullable = false)
>
> |-- d_date: date (nullable = true)
>
> |-- d_month_seq: integer (nullable = true)
>
> |-- d_week_seq: integer (nullable = true)
>
> |-- d_quarter_seq: integer (nullable = true)
>
> |-- d_year: integer (nullable = true)
>
> |-- d_dow: integer (nullable = true)
>
> |-- d_moy: integer (nullable = true)
>
> |-- d_dom: integer (nullable = true)
>
> |-- d_qoy: integer (nullable = true)
>
> |-- d_fy_year: integer (nullable = true)
>
> |-- d_fy_quarter_seq: integer (nullable = true)
>
> |-- d_fy_week_seq: integer (nullable = true)
>
> |-- d_day_name: string (nullable = true)
>
> |-- d_quarter_name: string (nullable = true)
>
> |-- d_holiday: string (nullable = true)
>
> |-- d_weekend: string (nullable = true)
>
> |-- d_following_holiday: string (nullable = true)
>
> |-- d_first_dom: integer (nullable = true)
>
> |-- d_last_dom: integer (nullable = true)
>
> |-- d_same_day_ly: integer (nullable = true)
>
> |-- d_same_day_lq: integer (nullable = true)
>
> |-- d_current_day: string (nullable = true)
>
> |-- d_current_week: string (nullable = true)
>
> |-- d_current_month: string (nullable = true)
>
> |-- d_current_quarter: string (nullable = true)
>
> |-- d_current_year: string (nullable = true)
>
>
>
> itemDF.printSchema()
>
> root
>
> |-- i_item_sk: integer (nullable = false)
>
> |-- i_item_id: string (nullable = false)
>
> |-- i_rec_start_date: date (nullable = true)
>
> |-- i_rec_end_date: date (nullable = true)
>
> |-- i_item_desc: string (nullable = true)
>
> |-- i_current_price: decimal (nullable = true)
>
> |-- i_wholesale_cost: decimal (nullable = true)
>
> |-- i_brand_id: integer (nullable = true)
>
> |-- i_brand: string (nullable = true)
>
> |-- i_class_id: integer (nullable = true)
>
> |-- i_class: string (nullable = true)
>
> |-- i_category_id: integer (nullable = true)
>
> |-- i_category: string (nullable = true)
>
> |-- i_manufact_id: integer (nullable = true)
>
> |-- i_manufact: string (nullable = true)
>
> |-- i_size: string (nullable = true)
>
> |-- i_formulation: string (nullable = true)
>
> |-- i_color: string (nullable = true)
>
> |-- i_units: string (nullable = true)
>
> |-- i_container: string (nullable = true)
>
> |-- i_manager_id: integer (nullable = true)
>
> |-- i_product_name: string (nullable = true)
>
>
>
> Regards,
>
> Ishwardeep
>
>
>
> *From:* ankitjindal [via Apache Spark User List] [mailto:ml-node+[hidden
> email] <http:///user/SendEmail.jtp?type=node&node=22768&i=0>]
> *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();
>  ------------------------------
>
> *If you reply to this email, your message will be added to the discussion
> below:*
>
>
> http://apache-spark-user-list.1001560.n3.nabble.com/Unable-to-join-table-across-data-sources-using-sparkSQL-tp22761p22766.html
>
> To unsubscribe from Unable to join table across data sources using
> sparkSQL, click here.
> NAML
> <http://apache-spark-user-list.1001560.n3.nabble.com/template/NamlServlet.jtp?macro=macro_viewer&id=instant_html%21nabble%3Aemail.naml&base=nabble.naml.namespaces.BasicNamespace-nabble.view.web.template.NabbleNamespace-nabble.view.web.template.NodeNamespace&breadcrumbs=notify_subscribers%21nabble%3Aemail.naml-instant_emails%21nabble%3Aemail.naml-send_instant_email%21nabble%3Aemail.naml>
>
> ------------------------------
>
>
>
>
>
>
> NOTE: This message may contain information that is confidential,
> proprietary, privileged or otherwise protected by law. The message is
> intended solely for the named addressee. If received in error, please
> destroy and notify the sender. Any use of this email is prohibited when
> received in error. Impetus does not represent, warrant and/or guarantee,
> that the integrity of this communication has been maintained nor that the
> communication is free of errors, virus, interception or interference.
>
> ------------------------------
> View this message in context: RE: Unable to join table across data
> sources using sparkSQL
> <http://apache-spark-user-list.1001560.n3.nabble.com/Unable-to-join-table-across-data-sources-using-sparkSQL-tp22761p22768.html>
> Sent from the Apache Spark User List mailing list archive
> <http://apache-spark-user-list.1001560.n3.nabble.com/> at Nabble.com.
>



-- 
Best Regards,
Ayan Guha

RE: Unable to join table across data sources using sparkSQL

Posted by Ishwardeep Singh <is...@impetus.co.in>.
Hi Ankit,

printSchema() works fine for all the tables.

hiveStoreSalesDF.printSchema()
root
|-- store_sales.ss_sold_date_sk: integer (nullable = true)
|-- store_sales.ss_sold_time_sk: integer (nullable = true)
|-- store_sales.ss_item_sk: integer (nullable = true)
|-- store_sales.ss_customer_sk: integer (nullable = true)
|-- store_sales.ss_cdemo_sk: integer (nullable = true)
|-- store_sales.ss_hdemo_sk: integer (nullable = true)
|-- store_sales.ss_addr_sk: integer (nullable = true)
|-- store_sales.ss_store_sk: integer (nullable = true)
|-- store_sales.ss_promo_sk: integer (nullable = true)
|-- store_sales.ss_ticket_number: integer (nullable = true)
|-- store_sales.ss_quantity: integer (nullable = true)
|-- store_sales.ss_wholesale_cost: double (nullable = true)
|-- store_sales.ss_list_price: double (nullable = true)
|-- store_sales.ss_sales_price: double (nullable = true)
|-- store_sales.ss_ext_discount_amt: double (nullable = true)
|-- store_sales.ss_ext_sales_price: double (nullable = true)
|-- store_sales.ss_ext_wholesale_cost: double (nullable = true)
|-- store_sales.ss_ext_list_price: double (nullable = true)
|-- store_sales.ss_ext_tax: double (nullable = true)
|-- store_sales.ss_coupon_amt: double (nullable = true)
|-- store_sales.ss_net_paid: double (nullable = true)
|-- store_sales.ss_net_paid_inc_tax: double (nullable = true)
|-- store_sales.ss_net_profit: double (nullable = true)

dateDimDF.printSchema()
root
|-- d_date_sk: integer (nullable = false)
|-- d_date_id: string (nullable = false)
|-- d_date: date (nullable = true)
|-- d_month_seq: integer (nullable = true)
|-- d_week_seq: integer (nullable = true)
|-- d_quarter_seq: integer (nullable = true)
|-- d_year: integer (nullable = true)
|-- d_dow: integer (nullable = true)
|-- d_moy: integer (nullable = true)
|-- d_dom: integer (nullable = true)
|-- d_qoy: integer (nullable = true)
|-- d_fy_year: integer (nullable = true)
|-- d_fy_quarter_seq: integer (nullable = true)
|-- d_fy_week_seq: integer (nullable = true)
|-- d_day_name: string (nullable = true)
|-- d_quarter_name: string (nullable = true)
|-- d_holiday: string (nullable = true)
|-- d_weekend: string (nullable = true)
|-- d_following_holiday: string (nullable = true)
|-- d_first_dom: integer (nullable = true)
|-- d_last_dom: integer (nullable = true)
|-- d_same_day_ly: integer (nullable = true)
|-- d_same_day_lq: integer (nullable = true)
|-- d_current_day: string (nullable = true)
|-- d_current_week: string (nullable = true)
|-- d_current_month: string (nullable = true)
|-- d_current_quarter: string (nullable = true)
|-- d_current_year: string (nullable = true)

itemDF.printSchema()
root
|-- i_item_sk: integer (nullable = false)
|-- i_item_id: string (nullable = false)
|-- i_rec_start_date: date (nullable = true)
|-- i_rec_end_date: date (nullable = true)
|-- i_item_desc: string (nullable = true)
|-- i_current_price: decimal (nullable = true)
|-- i_wholesale_cost: decimal (nullable = true)
|-- i_brand_id: integer (nullable = true)
|-- i_brand: string (nullable = true)
|-- i_class_id: integer (nullable = true)
|-- i_class: string (nullable = true)
|-- i_category_id: integer (nullable = true)
|-- i_category: string (nullable = true)
|-- i_manufact_id: integer (nullable = true)
|-- i_manufact: string (nullable = true)
|-- i_size: string (nullable = true)
|-- i_formulation: string (nullable = true)
|-- i_color: string (nullable = true)
|-- i_units: string (nullable = true)
|-- i_container: string (nullable = true)
|-- i_manager_id: integer (nullable = true)
|-- i_product_name: string (nullable = true)

Regards,
Ishwardeep

From: ankitjindal [via Apache Spark User List] [mailto:ml-node+s1001560n22766h71@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();
________________________________
If you reply to this email, your message will be added to the discussion below:
http://apache-spark-user-list.1001560.n3.nabble.com/Unable-to-join-table-across-data-sources-using-sparkSQL-tp22761p22766.html
To unsubscribe from Unable to join table across data sources using sparkSQL, click here<http://apache-spark-user-list.1001560.n3.nabble.com/template/NamlServlet.jtp?macro=unsubscribe_by_code&node=22761&code=aXNod2FyZGVlcC5zaW5naEBpbXBldHVzLmNvLmlufDIyNzYxfDgzMDExNzI4OQ==>.
NAML<http://apache-spark-user-list.1001560.n3.nabble.com/template/NamlServlet.jtp?macro=macro_viewer&id=instant_html%21nabble%3Aemail.naml&base=nabble.naml.namespaces.BasicNamespace-nabble.view.web.template.NabbleNamespace-nabble.view.web.template.NodeNamespace&breadcrumbs=notify_subscribers%21nabble%3Aemail.naml-instant_emails%21nabble%3Aemail.naml-send_instant_email%21nabble%3Aemail.naml>

________________________________






NOTE: This message may contain information that is confidential, proprietary, privileged or otherwise protected by law. The message is intended solely for the named addressee. If received in error, please destroy and notify the sender. Any use of this email is prohibited when received in error. Impetus does not represent, warrant and/or guarantee, that the integrity of this communication has been maintained nor that the communication is free of errors, virus, interception or interference.




--
View this message in context: http://apache-spark-user-list.1001560.n3.nabble.com/Unable-to-join-table-across-data-sources-using-sparkSQL-tp22761p22768.html
Sent from the Apache Spark User List mailing list archive at Nabble.com.

RE: Unable to join table across data sources using sparkSQL

Posted by Ishwardeep Singh <is...@impetus.co.in>.
Hi ,

I am using Spark 1.3.0.

I was able to join a JSON file on HDFS registered as a TempTable with a table in MySQL. On the same lines I tried to join a table in Hive with another table in Teradata but I get a query parse exception.

Regards,
Ishwardeep


From: ankitjindal [via Apache Spark User List] [mailto:ml-node+s1001560n22762h47@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 in it.

    Which spark version are you using currently?

Thanks
Ankit

________________________________
If you reply to this email, your message will be added to the discussion below:
http://apache-spark-user-list.1001560.n3.nabble.com/Unable-to-join-table-across-data-sources-using-sparkSQL-tp22761p22762.html
To unsubscribe from Unable to join table across data sources using sparkSQL, click here<http://apache-spark-user-list.1001560.n3.nabble.com/template/NamlServlet.jtp?macro=unsubscribe_by_code&node=22761&code=aXNod2FyZGVlcC5zaW5naEBpbXBldHVzLmNvLmlufDIyNzYxfDgzMDExNzI4OQ==>.
NAML<http://apache-spark-user-list.1001560.n3.nabble.com/template/NamlServlet.jtp?macro=macro_viewer&id=instant_html%21nabble%3Aemail.naml&base=nabble.naml.namespaces.BasicNamespace-nabble.view.web.template.NabbleNamespace-nabble.view.web.template.NodeNamespace&breadcrumbs=notify_subscribers%21nabble%3Aemail.naml-instant_emails%21nabble%3Aemail.naml-send_instant_email%21nabble%3Aemail.naml>

________________________________






NOTE: This message may contain information that is confidential, proprietary, privileged or otherwise protected by law. The message is intended solely for the named addressee. If received in error, please destroy and notify the sender. Any use of this email is prohibited when received in error. Impetus does not represent, warrant and/or guarantee, that the integrity of this communication has been maintained nor that the communication is free of errors, virus, interception or interference.




--
View this message in context: http://apache-spark-user-list.1001560.n3.nabble.com/Unable-to-join-table-across-data-sources-using-sparkSQL-tp22761p22763.html
Sent from the Apache Spark User List mailing list archive at Nabble.com.