[ https://issues.apache.org/jira/browse/SPARK-29630?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16961785#comment-16961785 ]
Takeshi Yamamuro commented on SPARK-29630: ------------------------------------------ Ah, I see. I'll recheck later. > Not allowed to create a permanent view by referencing a temporary view in > EXISTS > -------------------------------------------------------------------------------- > > Key: SPARK-29630 > URL: https://issues.apache.org/jira/browse/SPARK-29630 > Project: Spark > Issue Type: Improvement > Components: SQL > Affects Versions: 3.0.0 > Reporter: Takeshi Yamamuro > Priority: Major > > {code} > // In the master, the query below fails > $ CREATE VIEW v7_temp AS SELECT t1.id, t2.a FROM base_table t1, (SELECT * > FROM temp_table) t2; > org.apache.spark.sql.AnalysisException > Not allowed to create a permanent view `v7_temp` by referencing a temporary > view `temp_table`; > // In the master, the query below passed, but this should fail > $ CREATE VIEW v8_temp AS SELECT * FROM base_table WHERE EXISTS (SELECT 1 FROM > temp_table); > Passed > {code} -- This message was sent by Atlassian Jira (v8.3.4#803005) --------------------------------------------------------------------- To unsubscribe, e-mail: issues-unsubscr...@spark.apache.org For additional commands, e-mail: issues-h...@spark.apache.org