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

Forcibly create a temporary view in CREATE VIEW if referencing a temporary view

    XMLWordPrintableJSON

Details

    • Sub-task
    • Status: Resolved
    • Minor
    • Resolution: Won't Fix
    • 3.0.0
    • None
    • SQL
    • None

    Description

      CREATE TEMPORARY VIEW temp_table AS SELECT * FROM VALUES
        (1, 1) as temp_table(a, id);
      
      CREATE VIEW v1_temp AS SELECT * FROM temp_table;
      
      // In Spark
      org.apache.spark.sql.AnalysisException
      Not allowed to create a permanent view `v1_temp` by referencing a temporary view `temp_table`;
      
      // In PostgreSQL
      NOTICE:  view "v1_temp" will be a temporary view
      

      Attachments

        Issue Links

          Activity

            People

              Unassigned Unassigned
              maropu Takeshi Yamamuro
              Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved: