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 properties 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 excludes some properties
that are internal to spark and hive. The excluded properties are :
- All the properties that start with prefix
spark.sql
- Property keys such as:
EXTERNAL
,comment
- All the properties generated internally by hive to store statistics. Some of these
properties are:
numFiles
,numPartitions
,numRows
.
- All the properties that start with prefix