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