imback82 commented on a change in pull request #26361: [SPARK-29630][SQL] Disallow creating a permanent view that references a temporary view in an expression URL: https://github.com/apache/spark/pull/26361#discussion_r341902380
########## File path: sql/core/src/test/resources/sql-tests/results/postgreSQL/create_view.sql.out ########## @@ -887,35 +890,17 @@ AND NOT EXISTS (SELECT g FROM tbl4 LEFT JOIN tmptbl ON tbl4.h = tmptbl.j) -- !query 78 schema struct<> -- !query 78 output - +org.apache.spark.sql.AnalysisException +Not allowed to create a permanent view `mytempview` by referencing a temporary view `tmptbl`; Review comment: @maropu I couldn't just change it to `CREATE TABLE` since it complains about `Hive support is required to CREATE Hive TABLE (AS SELECT);`. So, I created a file based table and introduced `INSERT INTO`. This required me to regenerate the golden file, and the diff is not as pretty but it's just adding 1 to the subsequent queries. Please let me know if this approach is OK with you. Thanks! ---------------------------------------------------------------- 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: [email protected] With regards, Apache Git Services --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
