[GitHub] [spark] cloud-fan commented on a change in pull request #26731: [SPARK-30093][SQL] Improve error message for creating view

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

cloud-fan commented on a change in pull request #26731: [SPARK-30093][SQL] Improve error message for creating view
URL: https://github.com/apache/spark/pull/26731#discussion_r353242711
 
 

 ##########
 File path: sql/core/src/main/scala/org/apache/spark/sql/execution/command/views.scala
 ##########
 @@ -162,7 +162,7 @@ case class CreateViewCommand(
             if sparkSession.sessionState.catalog.isTemporaryTable(ident) =>
             // temporary views are only stored in the session catalog
             throw new AnalysisException(s"Not allowed to create a permanent view $name by " +
-              s"referencing a temporary view $ident")
+              s"referencing a temporary view $ident (use TEMPORARY keyword)")
 
 Review comment:
   nit: `... referencing a temporary view $ident. Please create a temp view instead by CREATE TEMP VIEW`

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