【FAQ】HIVE分区表 字段类型变更后产生has an incompatible Parquet schema for

异常

1、常见异常

StatementCallback; uncategorized SQLException for SQL [select * from `xxx` where time= 404]; SQL state [HY000]; error code [0]; File hdfs://xxx/xxx/time=0404/xxxxxxxxxx has an incompatible Parquet schema for column xxx.xxx. Column type: STRING, Parquet schema: optional int64 xxx [i:5 d:1 r:0] ; nested exception is java.sql.SQLException: File hdfs://xxx/xxx/time=0404/xxxxxxxxxx has an incompatible Parquet schema for column xxx.xxx. Column type: STRING, Parquet schema: optional int64 xxx [j:9 x:6 b:1]

StatementCallback; uncategorized SQLException for SQL [select * fromxxxwhere time= ‘0404’]; SQL state [HY000]; error code [0]; File ‘hdfs://xxx/xxx/time=0404/xxxxxxxxxx’ has an incompatible Parquet schema for column ‘xxx.xxx’. Column type: STRING, Parquet schema: optional int64 xxx [i:5 d:1

【FAQ】HIVE分区表 字段类型变更后产生has an incompatible Parquet schema for column ‘table.field‘. Column type: xxxx