hadoop - 更改表列名称拼写格式Hadoop

Question

我有带有列a，b，c的表。
hdfs上的数据存储为 Parquet ，即使该 Parquet 已经使用a，b，c模式编写，也可以更改特定的列名吗？

Answer 1

尝试使用ALTER TABLE

desc p;

+-------------------------+------------+----------+--+
|        col_name         | data_type  | comment  |
+-------------------------+------------+----------+--+
| category_id             | int        |          |
| category_department_id  | int        |          |
| category_name           | string     |          |
+-------------------------+------------+----------+--+

alter table p change column category_id id int

desc p;
+-------------------------+------------+----------+--+
|        col_name         | data_type  | comment  |
+-------------------------+------------+----------+--+
| id                      | int        |          |
| category_department_id  | int        |          |
| category_name           | string     |          |
+-------------------------+------------+----------+--+