Alter Table

• Change Columns

ALTER TABLE tablename
CHANGE COLUMN oldname newname coltype
[COMMENT 'comment']
[FIRST | AFTER colname];

 

• Add/Replace Columns

ALTER TABLE tablename
ADD | REPLACE COLUMNS
(colname1 coltype1 [COMMENT 'comment1'],
colname2 coltype2 [COMMENT 'comment2'];

 

• New Location

ALTER TABLE tablename
[PARTITION spec]
SET LOCATION 'new_loc';