spark-issues mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Ajesh Kumar (JIRA)" <j...@apache.org>
Subject [jira] [Created] (SPARK-15503) Not able to join two hive tables having partition using HiveContext.sql
Date Tue, 24 May 2016 09:19:12 GMT
Ajesh Kumar created SPARK-15503:
-----------------------------------

             Summary: 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


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
(v6.3.4#6332)

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


Mime
View raw message