[SPARK-29630] Not allowed to create a permanent view by referencing a temporary view in EXISTS

• Type: Sub-task
• Status: Resolved
• Priority: Major
• Resolution: Fixed
• Affects Version/s: 3.0.0
• Fix Version/s: 3.0.0
• Component/s: SQL
• Assignee: Terry Kim
• Reporter: Takeshi Yamamuro
• Created: 29/Oct/19 06:09
• Updated: 06/Jan/20 01:06
• Resolved: 05/Nov/19 05:21

Description

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

Issue Links

• links to: GitHub Pull Request #26361