Skip to content

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:

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|
+------+--------------------+----+-----------+--------------------+--------------------+-------------------+----------------+--------+-----------+----------+----------------+----------------+