SHOW TBLPROPERTIESSHOW TBLPROPERTIES

鉴于属性键的可选值,返回表属性的值。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

SHOW TBLPROPERTIES table_identifier
   [ ( unquoted_property_key | property_key_as_string_literal ) ]

参数Parameters

  • table_identifiertable_identifier

    • [database_name.] table_name:表名,可选择使用数据库名称进行限定。[database_name.] table_name: A table name, optionally qualified with a database name.
    • delta.`<path-to-table>`:现有 Delta 表的位置。delta.`<path-to-table>`: The location of an existing Delta table.
  • unquoted_property_keyunquoted_property_key

    不加引号的属性键。The property key in unquoted form. 键可以包含用点分隔的多个部分。The key may consists of multiple parts separated by dot.

    语法: [ key_part1 ] [ .key_part2 ] [ ... ]Syntax: [ key_part1 ] [ .key_part2 ] [ ... ]

  • property_key_as_string_literalproperty_key_as_string_literal

    字符串字面量形式的属性键值。A property key value as a string literal.

备注

此语句返回的属性值不包括 spark 和 hive 内部的某些属性。Property value returned by this statement excludes some properties that are internal to spark and hive. 排除的属性包括:The excluded properties are:

  • 以前缀 spark.sql 开头的所有属性All the properties that start with prefix spark.sql
  • 属性键,例如 EXTERNALcommentProperty keys such as: EXTERNAL, comment
  • 由 hive 在内部生成的用于存储统计信息的所有属性。All the properties generated internally by hive to store statistics. 其中一些属性包括:numFilesnumPartitionsnumRowsSome of these properties are: numFiles, numPartitions, numRows.

示例Examples

-- create a table `customer` in database `salesdb`
USE salesdb;
CREATE TABLE customer(cust_code INT, name VARCHAR(100), cust_addr STRING)
    TBLPROPERTIES ('created.by.user' = 'John', 'created.date' = '01-01-2001');

-- show all the user specified properties for table `customer`
SHOW TBLPROPERTIES customer;
+---------------------+----------+
|                  key|     value|
+---------------------+----------+
|      created.by.user|      John|
|         created.date|01-01-2001|
|transient_lastDdlTime|1567554931|
+---------------------+----------+

-- show all the user specified properties for a qualified table `customer`
-- in database `salesdb`
SHOW TBLPROPERTIES salesdb.customer;
+---------------------+----------+
|                  key|     value|
+---------------------+----------+
|      created.by.user|      John|
|         created.date|01-01-2001|
|transient_lastDdlTime|1567554931|
+---------------------+----------+

-- show value for unquoted property key `created.by.user`
SHOW TBLPROPERTIES customer (created.by.user);
+-----+
|value|
+-----+
| John|
+-----+

-- show value for property `created.date`` specified as string literal
SHOW TBLPROPERTIES customer ('created.date');
+----------+
|     value|
+----------+
|01-01-2001|
+----------+