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
|