@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-AlterTableProperties HTH *** If you found this answer addressed your question, please take a moment to login and click the "accept" link on the answer. ... View more