question Re: How can we change the column order in Hive table without deleting data. in Support Questions

How can we change the column order in Hive table without deleting data.

techshaj — Fri, 16 Sep 2022 14:19:56 GMT

Re: How can we change the column order in Hive table without deleting data.

Szczechla — Wed, 24 Apr 2019 21:42:27 GMT

Hi,

This command moves column_name after column_name2:

alter table table_name change column column_name column_name column_name_type after column_name2;

You have to put the column_name twice (or you can change column name) and type of the column.

Regards

Andrzej

Re: How can we change the column order in Hive table without deleting data.

EricL — Wed, 08 May 2019 04:35:29 GMT

If you change column order, it will affect existing data, so the new position of the column will match different data, that's OK for you?

Re: How can we change the column order in Hive table without deleting data.

techshaj — Fri, 10 May 2019 01:27:52 GMT

That's ok

Re: How can we change the column order in Hive table without deleting data.

Szczechla — Wed, 15 May 2019 09:00:25 GMT

@EricL

You are right - thank you for pointing this out.

Re: How can we change the column order in Hive table without deleting data.

shivani99 — Wed, 30 Nov 2022 14:40:02 GMT

In this solution, we are able to change position of a single column. Is it possible to change positions of 2 or more consecutive columns in the same way ?