[
https://issues.apache.org/jira/browse/SPARK-23036?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Apache Spark reassigned SPARK-23036:
------------------------------------
Assignee: Apache Spark
> Add withGlobalTempView for testing and correct some improper with view
> related method usage
> -------------------------------------------------------------------------------------------
>
> Key: SPARK-23036
> URL: https://issues.apache.org/jira/browse/SPARK-23036
> Project: Spark
> Issue Type: Bug
> Components: SQL
> Affects Versions: 2.2.1
> Reporter: xubo245
> Assignee: Apache Spark
>
> Add withGlobalTempView when create global temp view, like withTempView and
> withView.
> And correct some improper usage like:
> {code:java}
> test("list global temp views") {
> try {
> sql("CREATE GLOBAL TEMP VIEW v1 AS SELECT 3, 4")
> sql("CREATE TEMP VIEW v2 AS SELECT 1, 2")
> checkAnswer(sql(s"SHOW TABLES IN $globalTempDB"),
> Row(globalTempDB, "v1", true) ::
> Row("", "v2", true) :: Nil)
>
> assert(spark.catalog.listTables(globalTempDB).collect().toSeq.map(_.name) ==
> Seq("v1", "v2"))
> } finally {
> spark.catalog.dropTempView("v1")
> spark.catalog.dropGlobalTempView("v2")
> }
> }
> {code}
--
This message was sent by Atlassian JIRA
(v6.4.14#64029)
---------------------------------------------------------------------
To unsubscribe, e-mail: issues-unsubscr...@spark.apache.org
For additional commands, e-mail: issues-h...@spark.apache.org
