AnsweredAssumed Answered

Having Issues with Involving ORC format and external table

Question asked by bgajjela on Mar 22, 2016
Latest reply on Apr 20, 2016 by bgajjela

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. What could be the issue?

 

Thanks,

Bharath

Outcomes