I'm benchmarking some tables and want to confirm if and what type of compression has been enabled. My understanding is that there is input, intermediate/map and output compression -- is there a method to identify a table's compression status? I've set output compression like this:
And then used INSERT OVERWRITE to populate a table. Then I used:
hive> desc formatted table_name;
...which displays compression: No. So I wonder which compression type status is displayed in desc formatted? And is there a way to learn all compression type status for a table?
Sorry, Sreeman, never got an answer. Even spoke to a few of the Cloudera engineers and it didn't seem to be a big issue with anybody else -- I gave up.