修改表及实操案例

ALTER TABLE table_name RENAME TO new_table_name

hive (default)> alter table dept_partition2 rename to
dept_partition3;

ALTER TABLE table_name CHANGE [COLUMN] col_old_name col_new_name
column_type [COMMENT col_comment] [FIRST|AFTER column_name]

ALTER TABLE table_name ADD|REPLACE COLUMNS (col_name data_type
[COMMENT col_comment], ...) 

hive (default)> alter table dept_partition add columns(deptdesc
string);

hive (default)> alter table dept_partition change column
deptdesc desc int;

hive (default)> alter table dept_partition replace
columns(deptno string, dname
string, loc string);