ShowTableProperties Logical Command¶

ShowTableProperties is a logical command that represents SHOW TBLPROPERTIES SQL statement.

sql("SHOW TBLPROPERTIES d1").show(truncate = false)

+----------------------+-------+
|key                   |value  |
+----------------------+-------+
|Type                  |MANAGED|
|delta.minReaderVersion|1      |
|delta.minWriterVersion|2      |
+----------------------+-------+

Creating Instance¶

ShowTableProperties takes the following to be created:

• Table LogicalPlan
• (optional) Property Key

ShowTableProperties is created when:

• AstBuilder is requested to parse SHOW TBLPROPERTIES SQL statement

• ResolveCatalogs logical analyzer rule is executed

Output Attributes¶

output: Seq[Attribute]

output is part of the Command abstraction.

output is two AttributeReferences:

• key
• value

Both are of StringType and non-nullable.

Execution Planning¶

ShowTableProperties is resolved to ShowTablePropertiesCommand logical command using ResolveSessionCatalog logical resolution rule.

ShowTableProperties is planned to ShowTablePropertiesExec physical command using DataSourceV2Strategy execution planning strategy.