How can you change a column data type in Hive

Question

Can anyone explain how to change a data type in Hive?

Answer 1

Hi,

By using this command below one can change the column data type:

ALTER TABLE table_name CHANGE column_name column_name new_datatype;

I hope this works.

To know more about Big Data, It's recommended to join Data Architect Certification today.