+1 vote
in Hive by

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).

1 Answer

+1 vote
by
The following query will insert a new column:

ALTER TABLE h_table

CHANGE COLUMN new_col INT

BEFORE x_col

Related questions

+1 vote
asked Apr 3, 2020 in Big Data | Hadoop by Tate
+1 vote
asked Apr 6, 2020 in Big Data | Hadoop by GeorgeBell
...