hive-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "bharath kumar (JIRA)" <j...@apache.org>
Subject [jira] [Created] (HIVE-13328) Cannot Quey Hive External Returning 0 values
Date Tue, 22 Mar 2016 17:35:25 GMT
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)

Mime
View raw message