공부

[Hive] Alter table column change name

승가비 2019. 8. 18. 02:25
728x90
ALTER TABLE table_name CHANGE [COLUMN] col_old_name col_new_name column_type [COMMENT col_comment] [FIRST|AFTER column_name]

CREATE TABLE test_change (a int, b int, c int);
// will change column a's name to a1
ALTER TABLE test_change CHANGE a a1 INT;

[출처] https://stackoverflow.com/questions/22041316/hive-alter-table-change-column-name

728x90