[jira] [Commented] (SPARK-29628) Forcibly create a temporary view in CREATE VIEW if referencing a temporary view
[ https://issues.apache.org/jira/browse/SPARK-29628?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16961973#comment-16961973 ] Takeshi Yamamuro commented on SPARK-29628: -- Thanks! > Forcibly create a temporary view in CREATE VIEW if referencing a temporary > view > --- > > Key: SPARK-29628 > URL: https://issues.apache.org/jira/browse/SPARK-29628 > Project: Spark > Issue Type: Sub-task > Components: SQL >Affects Versions: 3.0.0 >Reporter: Takeshi Yamamuro >Priority: Minor > > {code} > 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 > {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
[jira] [Commented] (SPARK-29628) Forcibly create a temporary view in CREATE VIEW if referencing a temporary view
[ https://issues.apache.org/jira/browse/SPARK-29628?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16961758#comment-16961758 ] Aman Omer commented on SPARK-29628: --- Thanks [~maropu] . I will look into this one. > Forcibly create a temporary view in CREATE VIEW if referencing a temporary > view > --- > > Key: SPARK-29628 > URL: https://issues.apache.org/jira/browse/SPARK-29628 > Project: Spark > Issue Type: Sub-task > Components: SQL >Affects Versions: 3.0.0 >Reporter: Takeshi Yamamuro >Priority: Minor > > {code} > 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 > {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