- Subscribe to RSS Feed
- Mark Question as New
- Mark Question as Read
- Float this Question for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
How to validate which compression technique has been applied to hive?
- Labels:
-
Apache Hive
Created ‎07-21-2016 09:59 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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.
Created ‎07-21-2016 10:37 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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
Created ‎07-21-2016 06:17 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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"

- « Previous
-
- 1
- 2
- Next »