Support Questions
Find answers, ask questions, and share your expertise
Announcements
Alert: Welcome to the Unified Cloudera Community. Former HCC members be sure to read and learn how to activate your account here.

Changing column name in a Hive external table that contains data

Highlighted

Changing column name in a Hive external table that contains data

New Contributor

Hello folks ! I am new to Hadoop and Hive, and am from SQL server background! We have an external Parquet format hive table with column name insert_process_id. The table currently contains millions of data. We would like to change the column name to process_id. Please suggest how this can be done.