Github user gatorsmile commented on the issue:

    https://github.com/apache/spark/pull/14962
  
    Found a common bug in the following ALTER TABLE commands:
    ```
        | ALTER TABLE tableIdentifier (partitionSpec)?
            SET SERDE STRING (WITH SERDEPROPERTIES tablePropertyList)?     
#setTableSerDe
        | ALTER TABLE tableIdentifier (partitionSpec)?
            SET SERDEPROPERTIES tablePropertyList                          
#setTableSerDe
        | ALTER TABLE tableIdentifier ADD (IF NOT EXISTS)?
            partitionSpecLocation+                                         
#addTablePartition
        | ALTER VIEW tableIdentifier ADD (IF NOT EXISTS)?
            partitionSpec+                                                 
#addTablePartition
        | ALTER TABLE tableIdentifier
            from=partitionSpec RENAME TO to=partitionSpec                  
#renameTablePartition
        | ALTER TABLE tableIdentifier
            DROP (IF EXISTS)? partitionSpec (',' partitionSpec)* PURGE?    
#dropTablePartitions
        | ALTER VIEW tableIdentifier
            DROP (IF EXISTS)? partitionSpec (',' partitionSpec)*           
#dropTablePartitions
        | ALTER TABLE tableIdentifier partitionSpec? SET locationSpec      
#setTableLocation
        | ALTER TABLE tableIdentifier RECOVER PARTITIONS                   
#recoverPartitions
    ```
    
    We need to issue an exception when the tableType is `VIEW`. This is not 
introduced by this PR. Should we fix it here? or create a separate PR?


---
If your project is set up for it, you can reply to this email and have your
reply appear on GitHub as well. If your project does not have this feature
enabled and wishes so, or if the feature is enabled but not working, please
contact infrastructure at infrastruct...@apache.org or file a JIRA ticket
with INFRA.
---

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

Reply via email to