[ https://issues.apache.org/jira/browse/HIVE-1678?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12916789#action_12916789 ]
Amareshwari Sriramadasu commented on HIVE-1678: ----------------------------------------------- The following query : select /*+MAPJOIN(src, myinput1) */ count(srcpart.key) from srcpart join src on (srcpart.value=src.value) join myinput1 on (srcpart.key=myinput1.key); launches three MapReduce jobs in which third one fails with NPE. The task logs : {noformat} 2010-10-01 11:07:02,324 INFO ExecMapper: <MAP>Id =11 <Children> <SEL>Id =0 <Children> <MAPJOIN>Id =1 <Children> <FS>Id =2 <Parent>Id = 1 null<\Parent> <\FS> <\Children> <Parent>Id = 0 nullId = 3 <TS>Id =3 <Children>null <\Children> <\TS><\Parent> <\MAPJOIN> <\Children> <Parent>Id = 11 null<\Parent> <\SEL> <\Children> <\MAP> 2010-10-01 11:07:02,324 INFO org.apache.hadoop.hive.ql.exec.MapOperator: Initializing Self 11 MAP 2010-10-01 11:07:02,324 INFO org.apache.hadoop.hive.ql.exec.SelectOperator: Initializing Self 0 SEL 2010-10-01 11:07:02,327 INFO org.apache.hadoop.hive.ql.exec.SelectOperator: SELECT struct<_col0:int> 2010-10-01 11:07:02,332 INFO org.apache.hadoop.hive.ql.exec.SelectOperator: Operator 0 SEL initialized 2010-10-01 11:07:02,332 INFO org.apache.hadoop.hive.ql.exec.SelectOperator: Initializing children of 0 SEL 2010-10-01 11:07:02,332 INFO org.apache.hadoop.hive.ql.exec.MapJoinOperator: Initializing child 1 MAPJOIN 2010-10-01 11:07:02,332 INFO org.apache.hadoop.hive.ql.exec.SelectOperator: Initialization Done 0 SEL 2010-10-01 11:07:02,332 INFO org.apache.hadoop.hive.ql.exec.MapOperator: Initialization Done 11 MAP 2010-10-01 11:07:02,334 INFO org.apache.hadoop.hive.ql.exec.MapOperator: 11 forwarding 1 rows 2010-10-01 11:07:02,334 INFO org.apache.hadoop.hive.ql.exec.SelectOperator: 0 forwarding 1 rows 2010-10-01 11:07:02,338 FATAL ExecMapper: org.apache.hadoop.hive.ql.metadata.HiveException: Hive Runtime Error while processing row {"_col0":238} at org.apache.hadoop.hive.ql.exec.MapOperator.process(MapOperator.java:483) at org.apache.hadoop.hive.ql.exec.ExecMapper.map(ExecMapper.java:180) at org.apache.hadoop.mapred.MapRunner.run(MapRunner.java:50) at org.apache.hadoop.mapred.MapTask.runOldMapper(MapTask.java:395) at org.apache.hadoop.mapred.MapTask.run(MapTask.java:329) at org.apache.hadoop.mapred.Child$4.run(Child.java:219) 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:1021) at org.apache.hadoop.mapred.Child.main(Child.java:213) Caused by: java.lang.NullPointerException at org.apache.hadoop.hive.ql.exec.MapJoinOperator.processOp(MapJoinOperator.java:177) at org.apache.hadoop.hive.ql.exec.Operator.process(Operator.java:459) at org.apache.hadoop.hive.ql.exec.Operator.forward(Operator.java:710) at org.apache.hadoop.hive.ql.exec.SelectOperator.processOp(SelectOperator.java:84) at org.apache.hadoop.hive.ql.exec.Operator.process(Operator.java:459) at org.apache.hadoop.hive.ql.exec.Operator.forward(Operator.java:710) at org.apache.hadoop.hive.ql.exec.MapOperator.process(MapOperator.java:464) ... 9 more {noformat} >From the logs we can see that MapJoinOperator is not intialized at all. > NPE in MapJoin > --------------- > > Key: HIVE-1678 > URL: https://issues.apache.org/jira/browse/HIVE-1678 > Project: Hadoop Hive > Issue Type: Bug > Components: Query Processor > Reporter: Amareshwari Sriramadasu > > The query with two map joins and a group by fails with following NPE: > Caused by: java.lang.NullPointerException > at > org.apache.hadoop.hive.ql.exec.MapJoinOperator.processOp(MapJoinOperator.java:177) > at org.apache.hadoop.hive.ql.exec.Operator.process(Operator.java:457) > at org.apache.hadoop.hive.ql.exec.Operator.forward(Operator.java:697) > at > org.apache.hadoop.hive.ql.exec.SelectOperator.processOp(SelectOperator.java:84) > at org.apache.hadoop.hive.ql.exec.Operator.process(Operator.java:457) > at org.apache.hadoop.hive.ql.exec.Operator.forward(Operator.java:697) > at > org.apache.hadoop.hive.ql.exec.MapOperator.process(MapOperator.java:464) -- This message is automatically generated by JIRA. - You can reply to this email to add a comment to the issue online.