hive中的数组越界异常IndexOutOfBoundsException
java.lang.RuntimeException: Hive Runtime Error while closing operators
at org.apache.hadoop.ExecMapper.close(ExecMapper.java:226)
at org.apache.hadoop.mapred.MapRunner.run(MapRunner.java:57)
java中index是什么意思
at org.apache.hadoop.mapred.MapTask.runOldMapper(MapTask.java:418)
at org.apache.hadoop.mapred.MapTask.run(MapTask.java:333)
at org.apache.hadoop.mapred.Child$4.run(Child.java:268)
at java.security.AccessController.doPrivileged(Native Method)
at javax.security.auth.Subject.doAs(Subject.java:415)
at org.apache.hadoop.security.UserGroupInformation.doAs(UserGroupInformation.java:1408)
at org.apache.hadoop.mapred.Child.main(Child.java:262)
Caused by: org.apache.hadoop.adata.HiveException: java.lang.IndexOutOfBoundsException: Index: 10, Size: 10
at org.apache.hadoop.GroupByOperator.closeOp(GroupByOperator.java:1024)
at org.apache.hadoop.Operator.close(Operator.java:557)
at org.apache.hadoop.Operator.close(Operator.java:566)
at org.apache.hadoop.hive.ql
执⾏语句：
select user_id,indu_cd,brand_cd,prd_cd,media_cd,reg_cd,prov_cd,city_cd,sys_type,count(user_id) as
user_pv_cnts,count(distinct(user_id)) as user_cnts,pt_date from act_inter_sh_tele_pc where pt_date=20150628 and pt_hour = 06  group by user_id,indu_cd,brand_cd,prd_cd,media_cd,reg_cd,prov_cd,city_cd,sys_type,pt_date
在select中使⽤count（distinct 字段）对在后⾯的group by字段中的字段不能重复

版权声明：本站内容均来自互联网，仅供演示用，请勿用于商业和其他非法用途。如果侵犯了您的权益请与我们联系QQ:729038198，我们将在24小时内删除。