You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@hive.apache.org by "YihueyChyi (JIRA)" <ji...@apache.org> on 2008/12/10 08:48:44 UTC
[jira] Created: (HIVE-150) group by count(1) will get error
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.
[jira] Updated: (HIVE-150) group by count(1) will get error
Posted by "YihueyChyi (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/HIVE-150?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
YihueyChyi updated HIVE-150:
----------------------------
I download from
http://mirror.facebook.com/facebook/hive/hadoop-0.17/dist.tar.gz
> 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.
[jira] Commented: (HIVE-150) group by count(1) will get error
Posted by "Ashish Thusoo (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/HIVE-150?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12655314#action_12655314 ]
Ashish Thusoo commented on HIVE-150:
------------------------------------
Hi YihueyChyi,
As Zheng said that is really old code and does not have a lot of fixes. I will take it down this week so that there is not much confusion.
Please go to
http://svn.apache.org/repos/asf/hadoop/hive/trunk
to checkout the version of hive
and then
run ant -Dhadoop.version="0.17" clean package
This will generate the hive distribution in
build/dist
under
hive
set your HADOOP_HOME and then execute bin/hive
> 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.
[jira] Updated: (HIVE-150) group by count(1) will get error
Posted by "Raghotham Murthy (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/HIVE-150?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Raghotham Murthy updated HIVE-150:
----------------------------------
Attachment: hive-150.1.patch
Hi YihueyChyi,
There is an issue with service/build.xml. It currently assumes that you have thrift installed. I am attaching the diff which will allow the build to proceed even if you dont have thrift (this is ok since we are checking in the thrift generated code as well). Please apply this patch (by running patch -p0 < hive-150.1.patch in the hive top level directory.
> 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
> Components: Build Infrastructure
> Affects Versions: 0.20.0
> Environment: HADOOP 0.17.2.1
> Reporter: YihueyChyi
> Fix For: 0.20.0
>
> Attachments: hive-150.1.patch
>
>
> 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.
[jira] Resolved: (HIVE-150) group by count(1) will get error
Posted by "Zheng Shao (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/HIVE-150?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Zheng Shao resolved HIVE-150.
-----------------------------
Resolution: Fixed
Fix Version/s: (was: 0.20.0)
I guess the problem is already fixed in the new source repository. Reopen if there is still a problem.
> 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
> Components: Build Infrastructure
> Affects Versions: 0.20.0
> Environment: HADOOP 0.17.2.1
> Reporter: YihueyChyi
> Attachments: hive-150.1.patch
>
>
> 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.
[jira] Updated: (HIVE-150) group by count(1) will get error
Posted by "YihueyChyi (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/HIVE-150?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
YihueyChyi updated HIVE-150:
----------------------------
Thanks for your support.
I compiled successful.
> 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
> Components: Build Infrastructure
> Affects Versions: 0.20.0
> Environment: HADOOP 0.17.2.1
> Reporter: YihueyChyi
> Fix For: 0.20.0
>
> Attachments: hive-150.1.patch
>
>
> 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.
[jira] Commented: (HIVE-150) group by count(1) will get error
Posted by "Ashish Thusoo (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/HIVE-150?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12655320#action_12655320 ]
Ashish Thusoo commented on HIVE-150:
------------------------------------
cool..
then we should not be getting into this confusion for future users :)
> 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.
[jira] Commented: (HIVE-150) group by count(1) will get error
Posted by "Joydeep Sen Sarma (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/HIVE-150?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12655317#action_12655317 ]
Joydeep Sen Sarma commented on HIVE-150:
----------------------------------------
the mirror.facebook.com/hive site was already taken offlne.
> 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.
[jira] Commented: (HIVE-150) group by count(1) will get error
Posted by "Zheng Shao (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/HIVE-150?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12655773#action_12655773 ]
Zheng Shao commented on HIVE-150:
---------------------------------
Committed the patch from Raghu. But not closing this issue since this issue is about "group by count(1) will get error".
> 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
> Components: Build Infrastructure
> Affects Versions: 0.20.0
> Environment: HADOOP 0.17.2.1
> Reporter: YihueyChyi
> Fix For: 0.20.0
>
> Attachments: hive-150.1.patch
>
>
> 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.
[jira] Updated: (HIVE-150) group by count(1) will get error
Posted by "YihueyChyi (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/HIVE-150?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
YihueyChyi updated HIVE-150:
----------------------------
Fix Version/s: 0.20.0
Environment: HADOOP 0.17.2.1 (was: HADOOP 0.17.2.1 HIVE 0.17)
Affects Version/s: 0.20.0
> 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
> Components: Build Infrastructure
> Affects Versions: 0.20.0
> Environment: HADOOP 0.17.2.1
> Reporter: YihueyChyi
> Fix For: 0.20.0
>
>
> 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.
[jira] Updated: (HIVE-150) group by count(1) will get error
Posted by "YihueyChyi (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/HIVE-150?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
YihueyChyi updated HIVE-150:
----------------------------
Component/s: Build Infrastructure
Hi
I Build the Code ,but I get error like this:
thriftif:
[echo] Executing thrift (which needs to be in your path) to build java metastore APIs....
BUILD FAILED
/hive/trunk/build.xml:95: The following error occurred while executing this line:
/hive/trunk/service/build.xml:35: Execute failed: java.io.IOException: Cannot run program "thrift" (in directory "/hive/trunk/service"): java.io.IOException: error=2, No such file or directory
Please help. Thank you.
> 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
> Components: Build Infrastructure
> Affects Versions: 0.20.0
> Environment: HADOOP 0.17.2.1 HIVE 0.17
> Reporter: YihueyChyi
> Fix For: 0.20.0
>
>
> 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.
[jira] Commented: (HIVE-150) group by count(1) will get error
Posted by "Zheng Shao (JIRA)" <ji...@apache.org>.
[ 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.
[jira] Commented: (HIVE-150) group by count(1) will get error
Posted by "Zheng Shao (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/HIVE-150?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12655770#action_12655770 ]
Zheng Shao commented on HIVE-150:
---------------------------------
+1
> 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
> Components: Build Infrastructure
> Affects Versions: 0.20.0
> Environment: HADOOP 0.17.2.1
> Reporter: YihueyChyi
> Fix For: 0.20.0
>
> Attachments: hive-150.1.patch
>
>
> 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.