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)