Takeshi Yamamuro created SPARK-29630: ----------------------------------------
Summary: 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 {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