Uploaded image for project: 'Hive'
  1. Hive
  2. HIVE-5124

group by without map aggregation lead to mapreduce exception

Log workAgile BoardRank to TopRank to BottomBulk Copy AttachmentsBulk Move AttachmentsAdd voteVotersWatch issueWatchersCreate sub-taskConvert to sub-taskMoveLinkCloneLabelsUpdate Comment AuthorReplace String in CommentUpdate Comment VisibilityDelete Comments
    XMLWordPrintableJSON

Details

    • Bug
    • Status: Open
    • Major
    • Resolution: Unresolved
    • 0.11.0
    • None
    • Query Processor
    • None

    Description

      On my environment, the same query but diffent by seting hive.map.aggr with true or flase,produce different result.
      With hive.map.aggr=false,tasktracker report the following exception:
      java.lang.RuntimeException: Error in configuring object
      at org.apache.hadoop.util.ReflectionUtils.setJobConf(ReflectionUtils.java:93)
      at org.apache.hadoop.util.ReflectionUtils.setConf(ReflectionUtils.java:64)
      at org.apache.hadoop.util.ReflectionUtils.newInstance(ReflectionUtils.java:117)
      at org.apache.hadoop.mapred.ReduceTask.runOldReducer(ReduceTask.java:485)
      at org.apache.hadoop.mapred.ReduceTask.run(ReduceTask.java:420)
      at org.apache.hadoop.mapred.Child$4.run(Child.java:255)
      at java.security.AccessController.doPrivileged(Native Method)
      at javax.security.auth.Subject.doAs(Subject.java:396)
      at org.apache.hadoop.security.UserGroupInformation.doAs(UserGroupInformation.java:1083)
      at org.apache.hadoop.mapred.Child.main(Child.java:249)
      Caused by: java.lang.reflect.InvocationTargetException
      at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
      at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
      at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
      at java.lang.reflect.Method.invoke(Method.java:597)
      at org.apache.hadoop.util.ReflectionUtils.setJobConf(ReflectionUtils.java:88)
      ... 9 more
      Caused by: java.lang.RuntimeException: Reduce operator initialization failed
      at org.apache.hadoop.hive.ql.exec.ExecReducer.configure(ExecReducer.java:160)
      ... 14 more
      Caused by: java.lang.RuntimeException: cannot find field value from [0:_col0, 1:_col1, 2:_col2, 3:_col3]
      at org.apache.hadoop.hive.serde2.objectinspector.ObjectInspectorUtils.getStandardStructFieldRef(ObjectInspectorUtils.java:366)
      at org.apache.hadoop.hive.serde2.objectinspector.StandardStructObjectInspector.getStructFieldRef(StandardStructObjectInspector.java:143)
      at org.apache.hadoop.hive.ql.exec.ExprNodeColumnEvaluator.initialize(ExprNodeColumnEvaluator.java:82)
      at org.apache.hadoop.hive.ql.exec.GroupByOperator.initializeOp(GroupByOperator.java:299)
      at org.apache.hadoop.hive.ql.exec.Operator.initialize(Operator.java:375)
      at org.apache.hadoop.hive.ql.exec.Operator.initialize(Operator.java:451)
      at org.apache.hadoop.hive.ql.exec.Operator.initializeChildren(Operator.java:407)
      at org.apache.hadoop.hive.ql.exec.SelectOperator.initializeOp(SelectOperator.java:62)
      at org.apache.hadoop.hive.ql.exec.Operator.initialize(Operator.java:375)
      at org.apache.hadoop.hive.ql.exec.Operator.initialize(Operator.java:451)
      at org.apache.hadoop.hive.ql.exec.Operator.initializeChildren(Operator.java:407)
      at org.apache.hadoop.hive.ql.exec.GroupByOperator.initializeOp(GroupByOperator.java:438)
      at org.apache.hadoop.hive.ql.exec.Operator.initialize(Operator.java:375)
      at org.apache.hadoop.hive.ql.exec.ExecReducer.configure(ExecReducer.java:153)

      Attachments

        Activity

          This comment will be Viewable by All Users Viewable by All Users
          Cancel

          People

            Unassigned Unassigned Assign to me
            cyril.liao cyril liao

            Dates

              Created:
              Updated:

              Slack

                Issue deployment