Support Questions

Find answers, ask questions, and share your expertise
Announcements
Celebrating as our community reaches 100,000 members! Thank you!

How to validate which compression technique has been applied to hive?

avatar
Contributor

I have create table in hive and specified compression as gzip during table creation

I am not able to find way that gzip has been applied on newly created table

is there any command which specify compression technique applied on hive.

1 ACCEPTED SOLUTION

avatar
Contributor

I am able to resolve it. issue with create and select together.

I've created table first then inserted data, now able to see gzip as tableproperties in desc command

View solution in original post

10 REPLIES 10

avatar
Contributor

Thanks for reply..

I've one more question

the table properties showing that gzip has been applied,so i've created table post disabled hive compression.(disabled partition by setting as parquet.compress="none" in create table syntax and set hive.exec.compress.output"="false" )

but when i execute below command on both tables then i dont see any difference for size of withcompression or withoutcompression hive table.

command: $> hadoop fs -du -h hdfs://sandbox.hortonworks.com:8020/apps/hive/warehouse/tt1.

I've set below property in hive while enabling compression $>hive.exec.compress.output","true"