博客主要讲述了Hive的两个报错情况及解决办法。一是出现ClassCastException，将WritableStringObjectInspector转为LongObjectInspector失败，经调试发现是group by里某字段重复两次，删除其一后解决；二是编译语句报错，将WritableStringObjectInspector转为BooleanObjectInspector失败，是最外层group by语句中‘,’错写为‘and’，改正后解决。
#Hive报错
FAILED: ClassCastException org.apache.hadoop.hive.serde2.objectinspector.primitive.WritableStringObjectInspector cannot be cast to org.apache.hadoop.hive.serde2.objectinspector.primitive.LongObjectInspector
经debug后发现group by里某个字段重复出现两次，删除其中一个后，问题成功解决
#hive 报错
- Error while compiling statement: FAILED: ClassCastException org.apache.hadoop.hive.serde2.objectinspector.primitive.WritableStringObjectInspector cannot be cast to org.apache.hadoop.hive.serde2.objectinspector.primitive.BooleanObjectInspector
解决办法
在查看所有的语句全都没问题之后，发现在最外层的 group by 语句中，将 ‘,’ 错写为 ‘and’。该整治后解决
扫一扫
333
被折叠的 条评论
为什么被折叠?
到【灌水乐园】发言
