Question

Write a query to insert a new column(new_col INT) into a hive table (h_table) at a position before an existing column (x_col).

Answer 1

The following query will insert a new column:

ALTER TABLE h_table

CHANGE COLUMN new_col INT

BEFORE x_col