How to add column inside a table in Hive

Question

Hi,

Can anyone help me out, how to add column inside a table in hive? which command should I use?

Answer 1

Hi,

Yes, we can add column inside a table in Hive using a command:

ALTER TABLE table_name ADD COLUMNS (column _name datatypes);

I hope this will work.