The TBLPROPERTIES clause enables you to use your own metadata key/value pairs to tag the table definition.
There are also several predefined table properties, such as last-modified-user and last-modified-time, which Hive automatically adds and manages.
To view the properties of a table use the below command in hive prompt.
SHOW TBLPROPERTIES tblname;
This lists all the properties of the table.
If the table’s input format is ORC (refer to the input file formats) then you’ll see which compression (snappy or zlib) has opted. You’ll see if the transactional property set to true or false. You’ll also see the predefined table properties that managed by Hive.
Big Data & SQL 
1 comments