SHOW TBLPROPERTIES
Description
This statement returns the value of a table property given an optional value for a property key. If no key is specified then all the proerties are returned.
Syntax
Parameters
table_identifier
-
Specifies the table name of an existing table. The table may be optionally qualified
with a database name.
Syntax:[database_name.]table_name
unquoted_property_key
-
Specifies the property key in unquoted form. The key may consists of multiple
parts separated by dot.
Syntax:[key_part1][.key_part2][...]
property_key_as_string_literal
- Specifies a property key value as a string literal.
Note
- Property value returned by this statement exludes some properties
that are internal to spark and hive. The excluded properties are :
- All the properties that start with prefix
spark.sql
- Propery keys such as:
EXTERNAL
,comment
- All the properties generated intenally by hive to store statistics. Some of these
properties are:
numFiles
,numPartitions
,numRows
.
- All the properties that start with prefix