[ https://issues.apache.org/jira/browse/SPARK-16937?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15410991#comment-15410991 ]
Xiao Li commented on SPARK-16937: --------------------------------- We are using different name resolution rules, should we make them consistent? > Confusing behaviors when View and Temp View sharing the same names > ------------------------------------------------------------------ > > Key: SPARK-16937 > URL: https://issues.apache.org/jira/browse/SPARK-16937 > Project: Spark > Issue Type: Bug > Components: SQL > Affects Versions: 2.0.0 > Reporter: Xiao Li > > {noformat} > sql(s"CREATE TEMPORARY VIEW $viewName AS SELECT * FROM $tabName WHERE > ID < 3") > sql(s"CREATE VIEW $viewName AS SELECT * FROM $tabName") > // This returns the contents of the temp view. > sql(s"select * from $viewName").show(false) > // This returns the contents of the view. > sql(s"select * from default.$viewName").show(false) > // Below is to drop the temp view > sql(s"DROP VIEW $viewName") > // Both results are non-temp view > sql(s"select * from $viewName").show(false) > sql(s"select * from default.$viewName").show(false) > // After another drop, the non-temp view is dropped. > sql(s"DROP VIEW $viewName") > {noformat} -- This message was sent by Atlassian JIRA (v6.3.4#6332) --------------------------------------------------------------------- To unsubscribe, e-mail: issues-unsubscr...@spark.apache.org For additional commands, e-mail: issues-h...@spark.apache.org