Showing posts with label hive table properties; show tblproperties; display hive table definition; display hive metadata information;. Show all posts
Showing posts with label hive table properties; show tblproperties; display hive table definition; display hive metadata information;. Show all posts

Wednesday, September 30, 2020

Hive Table Properties

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

Hi Everybody, Please do visit my new blog that has much more information about Big Data and SQL. The site covers big data and almost all the...