You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@hive.apache.org by "Zheng Shao (JIRA)" <ji...@apache.org> on 2008/12/10 09:10:44 UTC
[jira] Commented: (HIVE-150) group by count(1) will get error
[ https://issues.apache.org/jira/browse/HIVE-150?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12655134#action_12655134 ]
Zheng Shao commented on HIVE-150:
---------------------------------
Can you get HIVE code from apache.org? We are not supporting the version on mirror.facebook.com any more.
> group by count(1) will get error
> --------------------------------
>
> Key: HIVE-150
> URL: https://issues.apache.org/jira/browse/HIVE-150
> Project: Hadoop Hive
> Issue Type: Bug
> Environment: HADOOP 0.17.2.1 HIVE 0.17
> Reporter: YihueyChyi
>
> HIVEQL: select l.http_user_agent,count(1) from log_resume_all l group by l.http_user_agent
> Maybe I'll get error in the second stage:
> FAILED: Execution Error, return code 2 from org.apache.hadoop.hive.ql.exec.ExecDriver
> The second stage :
> map error
> java.lang.NullPointerException
> at org.apache.hadoop.hive.ql.exec.ReduceSinkOperator.process(ReduceSinkOperator.java:151)
> at org.apache.hadoop.hive.ql.exec.Operator.forward(Operator.java:250)
> at org.apache.hadoop.hive.ql.exec.MapOperator.process(MapOperator.java:174)
> at org.apache.hadoop.hive.ql.exec.ExecMapper.map(ExecMapper.java:71)
> at org.apache.hadoop.mapred.MapRunner.run(MapRunner.java:47)
> at org.apache.hadoop.mapred.MapTask.run(MapTask.java:219)
> at org.apache.hadoop.mapred.TaskTracker$Child.main(TaskTracker.java:2122)
> syslog logs
> 2008-12-10 15:41:15,209 DEBUG org.apache.hadoop.mapred.TaskTracker: Child starting
> 2008-12-10 15:41:15,717 INFO org.apache.hadoop.metrics.jvm.JvmMetrics: Initializing JVM Metrics with processName=MAP, sessionId=
> 2008-12-10 15:41:15,805 INFO org.apache.hadoop.mapred.MapTask: numReduceTasks: 64
> 2008-12-10 15:41:16,252 INFO org.apache.hadoop.util.NativeCodeLoader: Loaded the native-hadoop library
> 2008-12-10 15:41:16,253 INFO org.apache.hadoop.io.compress.zlib.ZlibFactory: Successfully loaded & initialized native-zlib library
> 2008-12-10 15:41:16,424 INFO org.apache.hadoop.hive.ql.exec.MapOperator: Initializing Self
> 2008-12-10 15:41:16,428 INFO org.apache.hadoop.hive.ql.exec.MapOperator: Adding alias /tmp/hive-root/462573742/46102483.10002 to work list for file /tmp/hive-root/462573742/46102483.10002/0015_r_000029_0
> 2008-12-10 15:41:16,438 INFO org.apache.hadoop.hive.ql.exec.MapOperator: Got partitions: null
> 2008-12-10 15:41:16,438 INFO org.apache.hadoop.hive.ql.exec.ReduceSinkOperator: Initializing Self
> 2008-12-10 15:41:16,443 INFO org.apache.hadoop.hive.ql.exec.ReduceSinkOperator: Using tag = -1
> 2008-12-10 15:41:16,460 INFO org.apache.hadoop.hive.serde2.thrift.TBinarySortableProtocol: Sort order is ""
> 2008-12-10 15:41:16,460 INFO org.apache.hadoop.hive.serde2.thrift.TBinarySortableProtocol: Sort order is ""
> 2008-12-10 15:41:16,489 INFO org.apache.hadoop.hive.ql.exec.MapOperator: DESERIALIZE_ERRORS:0
> 2008-12-10 15:41:16,495 WARN org.apache.hadoop.mapred.TaskTracker: Error running child
> java.lang.NullPointerException
> at org.apache.hadoop.hive.ql.exec.ReduceSinkOperator.process(ReduceSinkOperator.java:151)
> at org.apache.hadoop.hive.ql.exec.Operator.forward(Operator.java:250)
> at org.apache.hadoop.hive.ql.exec.MapOperator.process(MapOperator.java:174)
> at org.apache.hadoop.hive.ql.exec.ExecMapper.map(ExecMapper.java:71)
> at org.apache.hadoop.mapred.MapRunner.run(MapRunner.java:47)
> at org.apache.hadoop.mapred.MapTask.run(MapTask.java:219)
> at org.apache.hadoop.mapred.TaskTracker$Child.main(TaskTracker.java:2122)
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.