DescribeDeltaDetailCommand (DescribeDeltaDetailCommandBase)¶

DescribeDeltaDetailCommand is a RunnableCommand (Spark SQL) for DESCRIBE DETAIL SQL command.

(DESC | DESCRIBE) DETAIL (path | table)

Creating Instance¶

DescribeDeltaDetailCommand takes the following to be created:

(optional) Table Path
(optional) Table identifier

DescribeDeltaDetailCommand is created when:

DeltaSqlAstBuilder is requested to parse DESCRIBE DETAIL SQL command)

run¶

run(
  sparkSession: SparkSession): Seq[Row]

run is part of the RunnableCommand (Spark SQL) abstraction.

run...FIXME

Demo¶

val q = sql("DESCRIBE DETAIL '/tmp/delta/users'")

scala> q.show
+------+--------------------+----+-----------+--------------------+--------------------+-------------------+----------------+--------+-----------+----------+----------------+----------------+
|format|                  id|name|description|            location|           createdAt|       lastModified|partitionColumns|numFiles|sizeInBytes|properties|minReaderVersion|minWriterVersion|
+------+--------------------+----+-----------+--------------------+--------------------+-------------------+----------------+--------+-----------+----------+----------------+----------------+
| delta|3799b291-dbfa-4f8...|null|       null|file:/tmp/delta/u...|2020-01-06 17:08:...|2020-01-06 17:12:28| [city, country]|       4|       2581|        []|               1|               2|
+------+--------------------+----+-----------+--------------------+--------------------+-------------------+----------------+--------+-----------+----------+----------------+----------------+