Support Questions
Find answers, ask questions, and share your expertise
Announcements
Alert: Welcome to the Unified Cloudera Community. Former HCC members be sure to read and learn how to activate your account here.

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

Highlighted

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

New Contributor

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