Found the solution:
ALTER TABLE tableA CHANGE ts ts BIGINT AFTER id;
See this for complete details: https://cwiki.apache.org/confluence/display/Hive/LanguageManual+DDL#LanguageManualDDL-AlterColumn
Found the solution:
ALTER TABLE tableA CHANGE ts ts BIGINT AFTER id;
See this for complete details: https://cwiki.apache.org/confluence/display/Hive/LanguageManual+DDL#LanguageManualDDL-AlterColumn