hive - Hive Alter表更改列名

Question

我正在尝试在Hive中重命名columnName。是否可以在Hive中重命名列名称。

tableA(栏1，_c1，_c2)
至
tableA(column1，column2，column3)
??

Answer 1

Change Column Name/Type/Position/Comment:

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;