You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@hive.apache.org by "bharath kumar (JIRA)" <ji...@apache.org> on 2016/03/22 18:35:25 UTC
[jira] [Created] (HIVE-13328) Cannot Quey Hive External Returning 0
values
bharath kumar created HIVE-13328:
------------------------------------
Summary: Cannot Quey Hive External Returning 0 values
Key: HIVE-13328
URL: https://issues.apache.org/jira/browse/HIVE-13328
Project: Hive
Issue Type: Bug
Components: Hive
Affects Versions: 0.13.0
Environment: MAPRFS
Reporter: bharath kumar
Priority: Blocker
Having Issues with Involving ORC format and external table.Below are the sequence of steps followed.
created an external table
using insert overwrite data is populated to external table with partition.
insert overwrite table external_table partition (data_date='2016-22-03')
select ....from (select * from db3.table1
where data_date = '2016-22-03') i
left join (select * from db3.table2 where data_date = '2016-22-03') th on i.column1 = th.column1 and
i.column2 = th.column2;
But when i query the external table data is not present. Tried below procedures like
ALTER TABLE NAME ADD PARTITION(DATA_DATE='2016-22-03');
MSCK REPAIR TABLE TABLENAME;
OK
Partitions not in metastore:
What could be the issue?
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)