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 theSales
table:Show partitions Sales ('numFiles');
Get Apache Hive Cookbook now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.