You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@spark.apache.org by "Dongjoon Hyun (JIRA)" <ji...@apache.org> on 2016/11/22 23:33:58 UTC
[jira] [Closed] (SPARK-18169) Suppress warnings when dropping views
on a dropped table
[ https://issues.apache.org/jira/browse/SPARK-18169?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Dongjoon Hyun closed SPARK-18169.
---------------------------------
Resolution: Fixed
> Suppress warnings when dropping views on a dropped table
> --------------------------------------------------------
>
> Key: SPARK-18169
> URL: https://issues.apache.org/jira/browse/SPARK-18169
> Project: Spark
> Issue Type: Bug
> Components: SQL
> Affects Versions: 2.0.0, 2.0.1
> Reporter: Dongjoon Hyun
> Priority: Minor
>
> Apache Spark 2.0.0 ~ 2.0.2-rc1 shows an inconsistent *AnalysisException* warning message when dropping a *view* on a dropped table. This does not happen on dropping *temporary views*. Also, Spark 1.6.x does not show warnings. We had better suppress this to be more consistent in Spark 2.x and with Spark 1.6.x.
> {code}
> scala> sql("create table t(a int)")
> scala> sql("create view v as select * from t")
> scala> sql("create temporary view tv as select * from t")
> scala> sql("drop table t")
> scala> sql("drop view tv")
> scala> sql("drop view v")
> 16/10/29 15:50:03 WARN DropTableCommand: org.apache.spark.sql.AnalysisException: Table or view not found: `default`.`t`; line 1 pos 91;
> 'SubqueryAlias v, `default`.`v`
> +- 'Project ['gen_attr_0 AS a#19]
> +- 'SubqueryAlias t
> +- 'Project ['gen_attr_0]
> +- 'SubqueryAlias gen_subquery_0
> +- 'Project ['a AS gen_attr_0#18]
> +- 'UnresolvedRelation `default`.`t`
> org.apache.spark.sql.AnalysisException: Table or view not found: `default`.`t`; line 1 pos 91;
> 'SubqueryAlias v, `default`.`v`
> +- 'Project ['gen_attr_0 AS a#19]
> +- 'SubqueryAlias t
> +- 'Project ['gen_attr_0]
> +- 'SubqueryAlias gen_subquery_0
> +- 'Project ['a AS gen_attr_0#18]
> +- 'UnresolvedRelation `default`.`t`
> ...
> res5: org.apache.spark.sql.DataFrame = []
> {code}
> Note that this is different case of dropping non-exist view. For the non-exist view, Spark raises NoSuchTableException.
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
---------------------------------------------------------------------
To unsubscribe, e-mail: issues-unsubscribe@spark.apache.org
For additional commands, e-mail: issues-help@spark.apache.org