[
https://issues.apache.org/jira/browse/SPARK-17502?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Xiao Li updated SPARK-17502:
----------------------------
Description:
- When the permanent tables/views do not exist but the temporary view exists,
the expected error should be `NoSuchTableException` for partition-related ALTER
TABLE commands. However, it always reports a confusing error message. For
example,
{noformat}
Partition spec is invalid. The spec (a, b) must match the partition spec ()
defined in table '`testview`';
{noformat}
- When the permanent tables/views do not exist but the temporary view exists,
the expected error should be `NoSuchTableException` for `ALTER TABLE ... UNSET
TBLPROPERTIES`. However, it reports missing table property. However, the
expected error should be `NoSuchTableException`. For example,
{noformat}
Attempted to unset non-existent property 'p' in table '`testView`';
{noformat}
- When `ANALYZE TABLE` is called on a view or a temporary view, we should issue
an error message. However, it reports a strange error:
{noformat}
ANALYZE TABLE is not supported for Project
{noformat}
was:
- When the permanent tables/views do not exist but the temporary view exists,
the expected error should be `NoSuchTableException` for partition-related ALTER
TABLE commands. However, it always reports a confusing error message. For
example,
{noformat}
Partition spec is invalid. The spec (a, b) must match the partition spec ()
defined in table '`testview`';
{noformat}
- When the permanent tables/views do not exist but the temporary view exists,
the expected error should be `NoSuchTableException` for `ALTER TABLE ... UNSET
TBLPROPERTIES`. However, it reports missing table property. However, the
expected error should be `NoSuchTableException`. For example,
{noformat}
Attempted to unset non-existent property 'p' in table '`testView`';
{noformat}
> Multiple Bugs in DDL Statements on Temporary Views
> ---------------------------------------------------
>
> Key: SPARK-17502
> URL: https://issues.apache.org/jira/browse/SPARK-17502
> Project: Spark
> Issue Type: Bug
> Components: SQL
> Affects Versions: 2.0.1, 2.1.0
> Reporter: Xiao Li
>
> - When the permanent tables/views do not exist but the temporary view exists,
> the expected error should be `NoSuchTableException` for partition-related
> ALTER TABLE commands. However, it always reports a confusing error message.
> For example,
> {noformat}
> Partition spec is invalid. The spec (a, b) must match the partition spec ()
> defined in table '`testview`';
> {noformat}
> - When the permanent tables/views do not exist but the temporary view exists,
> the expected error should be `NoSuchTableException` for `ALTER TABLE ...
> UNSET TBLPROPERTIES`. However, it reports missing table property. However,
> the expected error should be `NoSuchTableException`. For example,
> {noformat}
> Attempted to unset non-existent property 'p' in table '`testView`';
> {noformat}
> - When `ANALYZE TABLE` is called on a view or a temporary view, we should
> issue an error message. However, it reports a strange error:
> {noformat}
> ANALYZE TABLE is not supported for Project
> {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
