hive 更改列的位置时遇到的问题

hive > desc formatted tb_fq;
OK
col_name    data_type    comment
# col_name                data_type               comment                       
name                    string                                      
age                     int                                         
fdate                   date                                        
userid                  string                                      
myid                    int                                         
          
# Partition Information          
# col_name                data_type               comment                       
time                    date 


hive > alter table tb_fq change column myid myid int after name ;
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 :
age,fdate

感觉只要是列的类型不同列换位置就行不通啊！并且这种更换只是元数据换了，里面存的数据还是原来的！鸡肋操作

转载于:https://www.cnblogs.com/qiuhong10/p/7600445.html