[jira] [Assigned] (HIVE-13328) Cannot Quey Hive External Returning 0 values

["Arun Kumar Srinivasan (JIRA)" <ji...@apache.org>]

     [ https://issues.apache.org/jira/browse/HIVE-13328?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Arun Kumar Srinivasan reassigned HIVE-13328:
--------------------------------------------

    Assignee: Arun Kumar Srinivasan

> 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
>            Assignee: Arun Kumar Srinivasan
>            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)