티스토리 뷰

공부

[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

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

[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
댓글
댓글쓰기 폼