[ 
https://issues.apache.org/jira/browse/SPARK-18549?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
 ]

Wenchen Fan updated SPARK-18549:
--------------------------------
    Fix Version/s: 2.1.1

> Failed to Uncache a View that References a Dropped Table.
> ---------------------------------------------------------
>
>                 Key: SPARK-18549
>                 URL: https://issues.apache.org/jira/browse/SPARK-18549
>             Project: Spark
>          Issue Type: Bug
>          Components: SQL
>    Affects Versions: 2.0.2
>            Reporter: Xiao Li
>            Assignee: Wenchen Fan
>            Priority: Critical
>             Fix For: 2.1.1, 2.2.0
>
>
> {code}
>       spark.range(1, 10).toDF("id1").write.format("json").saveAsTable("jt1")
>       spark.range(1, 10).toDF("id2").write.format("json").saveAsTable("jt2")
>       sql("CREATE VIEW testView AS SELECT * FROM jt1 JOIN jt2 ON id1 == id2")
>       // Cache is empty at the beginning
>       assert(spark.sharedState.cacheManager.isEmpty)
>       sql("CACHE TABLE testView")
>       assert(spark.catalog.isCached("testView"))
>       // Cache is not empty
>       assert(!spark.sharedState.cacheManager.isEmpty)
> {code}
> {code}
>       // drop a table referenced by a cached view
>       sql("DROP TABLE jt1")
> -- So far everything is fine
>       // Failed to unache the view
>       val e = intercept[AnalysisException] {
>         sql("UNCACHE TABLE testView")
>       }.getMessage
>       assert(e.contains("Table or view not found: `default`.`jt1`"))
>       // We are unable to drop it from the cache
>       assert(!spark.sharedState.cacheManager.isEmpty)
> {code}



--
This message was sent by Atlassian JIRA
(v6.3.15#6346)

---------------------------------------------------------------------
To unsubscribe, e-mail: issues-unsubscr...@spark.apache.org
For additional commands, e-mail: issues-h...@spark.apache.org

Reply via email to