[GitHub] [spark] viirya commented on a change in pull request #27505: [SPARK-27946][SQL][FOLLOW-UP] Change doc and error message for SHOW CREATE TABLE

[GitBox <gi...@apache.org>]

viirya commented on a change in pull request #27505: [SPARK-27946][SQL][FOLLOW-UP] Change doc and error message for SHOW CREATE TABLE
URL: https://github.com/apache/spark/pull/27505#discussion_r376831132
 
 

 ##########
 File path: sql/core/src/main/scala/org/apache/spark/sql/execution/command/tables.scala
 ##########
 @@ -1076,7 +1076,9 @@ case class ShowCreateTableCommand(table: TableIdentifier)
             "Failed to execute SHOW CREATE TABLE against table " +
               s"${tableMetadata.identifier}, which is created by Hive and uses the " +
               "following unsupported feature(s)\n" +
-              tableMetadata.unsupportedFeatures.map(" - " + _).mkString("\n")
+              tableMetadata.unsupportedFeatures.map(" - " + _).mkString("\n") + ". " +
+              s"Please use `SHOW CREATE TABLE ${tableMetadata.identifier} AS SERDE` " +
+              "to show Hive DDL instead."
 
 Review comment:
   Yea, test case `hive partitioned view is not supported` in `HiveShowCreateTableSuite` is for this error.

----------------------------------------------------------------
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:
users@infra.apache.org


With regards,
Apache Git Services

---------------------------------------------------------------------
To unsubscribe, e-mail: reviews-unsubscribe@spark.apache.org
For additional commands, e-mail: reviews-help@spark.apache.org