Apache Hive Cookbook

Show the table properties

In this recipe, you will learn how to list all the properties of a table in Hive.

Getting ready

This command lists the properties of a table. The general syntax for showing table properties is as follows:

SHOW TBLPROPERTIES tblname;

How to do it…

Use these commands to show table properties in Hive:

• This command will list all the properties for the Sales table:

  Show tblproperties Sales;
  

• The preceding command will list only the property for numFiles in the Sales table:

  Show partitions Sales ('numFiles');