[Hive] Alter table column change name

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

저작자표시비영리

'공부' 카테고리의 다른 글

[Hive] INSERT OVERWRITE  (0)	2019.08.18
[Hive] Show create sql  (0)	2019.08.18
[Hive] Alter table column change name  (0)	2019.08.18
[Hive] auto partition adding  (0)	2019.08.18
[SQL] `NOT IN` & `NOT EXISTS` too slow  (0)	2019.08.17
[crontab] python3 not working  (0)	2019.08.17