szehon-ho commented on code in PR #58092: URL: https://github.com/apache/spark/pull/58092#discussion_r3824167117
########## docs/sql-ref-syntax-aux-describe-table.md: ########## @@ -26,6 +26,13 @@ table. The metadata information includes column name, column type and column comment. Optionally a partition spec or column name may be specified to return the metadata pertaining to a partition or column respectively. +If a table's declared partition columns do not match the last columns of its schema, the catalog +metadata is inconsistent. `DESCRIBE TABLE` still returns the rest of the metadata, and reports +both column lists under an `# Invalid Partition Information` section in place of the usual +`# Partition Information` section. Repair such a table so that its declared partition columns +match the last columns of its schema; until then, commands that require the partition schema, +such as `DESCRIBE TABLE ... PARTITION`, `SHOW PARTITIONS` and `SHOW CREATE TABLE`, keep failing. Review Comment: Thanks, that was overstated. The docs no longer list unfiltered `SHOW PARTITIONS` or plain `SHOW CREATE TABLE` as failing. The note now only mentions the partition-spec forms that still call `partitionSchema`: `DESCRIBE TABLE ... PARTITION`, `SHOW TABLE EXTENDED ... PARTITION`, and `SHOW PARTITIONS ... PARTITION`. -- This is an automated message from the Apache Git Service. To respond to the message, please log on to GitHub and use the URL above to go to the specific comment. To unsubscribe, e-mail: [email protected] For queries about this service, please contact Infrastructure at: [email protected] --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
