You are viewing a plain text version of this content. The canonical link for it is here.

Posted to user@hive.apache.org by Daniel Haviv <da...@veracity-group.com> on 2015/01/19 07:11:13 UTC

Trying to improve compression ratio for an ORC table

Hi guys,
I'm experiencing something very odd:
I have an ORC table with the "orc.compress"="SNAPPY" property that weighs
4.9 GB and is composed of 253 files..
I then do a CTAS into a new table where I added this
property "orc.compress.size"="2485760" to improve the compression ratio.

The new table weighs 5.2 GB over 18 files so not only did the compression
ratio not improve, it got worse.

How can this be ?

Thanks,
Daniel