Hive
因大妖
如无必要,勿增实体
展开
-
使用hive查询hdfs数据时报字段类型异常
报错信息:Caused by: org.apache.hadoop.hive.ql.metadata.HiveException: java.lang.ClassCastException: org.openx.data.jsonserde.json.JSONArray cannot be cast to java.lang.Integer报错原因:原因是hive 元数据表中定义的原创 2017-02-09 09:13:18 · 1445 阅读 · 0 评论 -
Hive Could not find status of job
报警信息:Caused by: HiveServerException(message:Query returned non-zero code: 1, cause: FAILED: Execution Error, return code 1 from org.apache.hadoop.hive.ql.exec.mr.MapRedTask, errorCode:1, SQLStat原创 2017-03-19 13:21:11 · 3182 阅读 · 0 评论 -
hive left outer join 两次
有时候查询hive表的时候需要用到两次的left outer join ,在这里做如下笔记select x.id,x.name from (select m.id ,m.name from ( select id , name from A ) m left outer join (select id , name from B ) n on m.id原创 2017-03-11 13:25:20 · 1055 阅读 · 0 评论 -
Hive Job status not available
收到的报警信息:Caused by: HiveServerException(message:Query returned non-zero code: 1, cause: FAILED: Execution Error, return code 1 from org.apache.hadoop.hive.ql.exec.mr.MapRedTask, errorCode:1, SQLState原创 2017-03-16 09:29:58 · 1505 阅读 · 0 评论 -
Hive Process forward class cast error exceed 1000
报警信息如下:Diagnostic Messages for this Task:Error: java.lang.RuntimeException: org.apache.hadoop.hive.ql.metadata.HiveException: Process forward class cast error exceed 1000, [Error getting row data原创 2017-03-16 12:30:23 · 610 阅读 · 0 评论