Reply
Highlighted
New Contributor
Posts: 3
Registered: ‎07-14-2016

Hive Join - Snappy Compression Vs Non Compressed Table - Not Working

Hi All,

 

I have a table1 which is snappy compressed and the other table2 without snappy compressed. so when i do a join between them it yields no results.

 

select a.cname,b.*
from (select * from Table1 where cname = somevalue)
join (select * from Table2 where cname1 = somevalue) b

 

But when both the tables are snappy compressed it gives the results.

 

 

So the question are

 

1)Is it manadatory when joining both the table should posses same compression

2)Is there any way where i can set some parameter to not consider snappy and do join on both tables.

 

Thanks,

Janani