beliefer commented on a change in pull request #31245:
URL: https://github.com/apache/spark/pull/31245#discussion_r571519198
##########
File path: docs/sql-migration-guide.md
##########
@@ -40,6 +40,10 @@ license: |
- In Spark 3.2, script transform default FIELD DELIMIT is `\u0001` for no
serde mode, serde property `field.delim` is `\t` for Hive serde mode when user
specifies serde. In Spark 3.1 or earlier, the default FIELD DELIMIT is `\t`,
serde property `field.delim` is `\u0001` for Hive serde mode when user
specifies serde.
- In Spark 3.2, the auto-generated `Cast` (such as those added by type
coercion rules) will be stripped when generating column alias names. E.g.,
`sql("SELECT floor(1)").columns` will be `FLOOR(1)` instead of `FLOOR(CAST(1 AS
DOUBLE))`.
+
+ - In Spark 3.2, the output schema of `SHOW TABLES` becomes `namespace:
string, tableName: string, isTemporary: boolean`. In Spark 3.1 or earlier, the
`namespace` field was named `database` for the builtin catalog, and there is no
`isTemporary` field for v2 catalogs. Since Spark 3.2, to restore the old schema
with the builtin catalog, you can set
`spark.sql.legacy.keepCommandOutputSchema` to `true`.
Review comment:
OK
----------------------------------------------------------------
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.
For queries about this service, please contact Infrastructure at:
us...@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: reviews-unsubscr...@spark.apache.org
For additional commands, e-mail: reviews-h...@spark.apache.org
