insert overwrite to hive orc table in aws

[Sowjanya Kakarala]

Hi Guys,

I am new to aws, I am not sure how the hive works and store the data in aws.

I have created a text table and orc table. where text table have data and
when I do insert overwrite from text table the qury runs fine and when I do
a count on orc table its zero.

I have no clue where the data is going, any suggestions or ideas?

Here is my query: