Archives of Support Questions (Read Only)

This is an archived board for historical reference. Information and links may no longer be available or relevant
Announcements
This board is archived and read-only for historical reference. To ask a new question, please post a new topic on the appropriate active board.

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

avatar
New Member

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
New Member

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
New Member

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"