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:
SET hive.exec.compress.output=true;
SET mapred.max.split.size=256000000;
SET mapred.output.compression.type=BLOCK;
SET mapred.output.compression.codec=org.apache.hadoop.io.compress.SnappyCodec;
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?
