How to add a column in Hive table

Question

Hi Team,

I have created a Hive table. I want to add a new column to the table. How can I do that?

Answer 1

Hi@akhtar,

You can use the alter table command to add a new column to the hive table. This command can alter your table according to your requirement as shown below.

$ ALTER TABLE employee ADD COLUMNS (dept STRING COMMENT 'Department name');