ALTER TABLE r__wooer_nums_retention_d CHANGE column platformname platformname bigint ;
Error: Error while processing statement: FAILED: Execution Error, return code 1 from org.apache.hadoop.hive.ql.exec.DDLTask. Unable to alter table. The following columns have types incompatible with the existing columns in their respective positions :
详见 https://stackoverflow.com/questions/36837266/change-column-type-in-hive
总结,高阶字符串(string)无法转化为低阶字符串(bigint)