Uploaded image for project: 'Spark'
  1. Spark
  2. SPARK-27764 Feature Parity between PostgreSQL and Spark
  3. SPARK-29630

Not allowed to create a permanent view by referencing a temporary view in EXISTS

    XMLWordPrintableJSON

Details

    • Sub-task
    • Status: Resolved
    • Major
    • Resolution: Fixed
    • 3.0.0
    • 3.0.0
    • SQL
    • None

    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
      

      Attachments

        Issue Links

          Activity

            People

              imback82 Terry Kim
              maropu Takeshi Yamamuro
              Votes:
              0 Vote for this issue
              Watchers:
              4 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved: