[SPARK-17502] Multiple Bugs in DDL Statements on Temporary Views - ASF JIRA

XML

Word

Printable

JSON

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,
```
Partition spec is invalid. The spec (a, b) must match the partition spec () defined in table '`testview`';
```
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,
```
Attempted to unset non-existent property 'p' in table '`testView`';
```
When `ANALYZE TABLE` is called on a view or a temporary view, we should issue an error message. However, it reports a strange error:
```
ANALYZE TABLE is not supported for Project
```

links to

[Github] Pull Request #15054 (gatorsmile)