how to a add specific column between the columns in hive?

[#1]

@Sura Reddy Have you tried with

// Next change column a1's name to a2, its data type to string, and put it after column b.
ALTER TABLE test_change CHANGE a1 a2 STRING AFTER b;

This is documented as part of https://cwiki.apache.org/confluence/display/Hive/LanguageManual+DDL#LanguageManualDDL-AlterTableProp...

HTH

*** If you found this answer addressed your question, please take a moment to login and click the "accept" link on the answer.