You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@spark.apache.org by "Hyukjin Kwon (JIRA)" <ji...@apache.org> on 2019/05/21 04:38:21 UTC
[jira] [Resolved] (SPARK-15503) Not able to join two hive tables
having partition using HiveContext.sql
[ https://issues.apache.org/jira/browse/SPARK-15503?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Hyukjin Kwon resolved SPARK-15503.
----------------------------------
Resolution: Incomplete
> Not able to join two hive tables having partition using HiveContext.sql
> -----------------------------------------------------------------------
>
> Key: SPARK-15503
> URL: https://issues.apache.org/jira/browse/SPARK-15503
> Project: Spark
> Issue Type: Bug
> Reporter: Ajesh Kumar
> Priority: Major
> Labels: bulk-closed
>
> I have created two hive tables with partition.
> create external table testtable3(emp_id STRING,emp_name STRING,employer_id STRING) partitioned by (date String) ROW FORMAT DELIMITED FIELDS TERMINATED BY ',' location '/testtable3';
> create external table testtable2(employer_id STRING,employer_name STRING) partitioned by (date String) ROW FORMAT DELIMITED FIELDS TERMINATED BY ',' location '/testtable2';
> If I execute the below join query in hive console, it is working fine.
> select * from testtable3 t3 join testtable2 t2 on t3.employer_id=t2.employer_id
> But if I try to execute it using HiveContext sql, it is not returning any output.
--
This message was sent by Atlassian JIRA
(v7.6.3#76005)
---------------------------------------------------------------------
To unsubscribe, e-mail: issues-unsubscribe@spark.apache.org
For additional commands, e-mail: issues-help@spark.apache.org