How to change datatype of a column in hive
Incidentally, I used an incorrect datatype while creating the table in Hive. Now I want to change the datatype without dropping the table.
Can you please tell me how to change the datatype of a column in the hive?
Yes, you can change the datatype of an existing column without dropping it.
Here is the query-
ALTER TABLE table_name CHANGE col_name col_name newType