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

[#1]

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 ?

[#2]

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?

[#3]

That's ok

[#4]

@EricL 

You are right - thank you for pointing this out.