java.lang.RuntimeException: Hive Runtime Error while closing operators at org.apache.hadoop.hive.ql.exec.ExecMapper.close(ExecMapper.java:226) at org.apache.hadoop.mapred.MapRunner.run(MapRunner.java:57) 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.hive.ql.metadata.HiveException: java.lang.IndexOutOfBoundsException: Index: 10, Size: 10 at org.apache.hadoop.hive.ql.exec.GroupByOperator.closeOp(GroupByOperator.java:1024) at org.apache.hadoop.hive.ql.exec.Operator.close(Operator.java:557) at org.apache.hadoop.hive.ql.exec.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
![]()
![]()
![]()
https://issues.apache.org/jira/browse/HIVE-4237 网站上的解释
![]()
![]()
在select中使用count(distinct 字段)对在后面的group by字段中的字段 不能重复