hive-issues mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Rui Li (JIRA)" <j...@apache.org>
Subject [jira] [Commented] (HIVE-14557) Nullpointer When both SkewJoin and Mapjoin Enabled
Date Thu, 16 Mar 2017 09:03:41 GMT

    [ https://issues.apache.org/jira/browse/HIVE-14557?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15927693#comment-15927693
] 

Rui Li commented on HIVE-14557:
-------------------------------

Change looks good to me. +1 pending test

> Nullpointer When both SkewJoin  and Mapjoin Enabled
> ---------------------------------------------------
>
>                 Key: HIVE-14557
>                 URL: https://issues.apache.org/jira/browse/HIVE-14557
>             Project: Hive
>          Issue Type: Bug
>          Components: Physical Optimizer
>    Affects Versions: 1.1.0, 2.1.0
>            Reporter: Nemon Lou
>         Attachments: HIVE-14557.patch
>
>
> The following sql failed with return code 2 on mr.
> {noformat}
> create table a(id int,id1 int);
> create table b(id int,id1 int);
> create table c(id int,id1 int);
> set hive.optimize.skewjoin=true;
> select a.id,b.id,c.id1 from a,b,c where a.id=b.id and a.id1=c.id1;
> {noformat}
> Error log as follows:
> {noformat}
> 2016-08-17 21:13:42,081 INFO [main] org.apache.hadoop.hive.ql.exec.mr.ExecMapper: 
> <MAP>Id =0
>   <Children>
>     <TS>Id =21
>       <Children>
>         <MAPJOIN>Id =28
>           <Children>
>             <FS>Id =16
>               <Children>
>               <\Children>
>               <Parent>Id = 28 null<\Parent>
>             <\FS>
>           <\Children>
>           <Parent>Id = 21 nullId = 33 
>         <HASHTABLEDUMMY>Id =33
>           <Children>null
>           <\Children>
>           <Parent><\Parent>
>         <\HASHTABLEDUMMY><\Parent>
>         <\MAPJOIN>
>       <\Children>
>       <Parent>Id = 0 null<\Parent>
>     <\TS>
>   <\Children>
>   <Parent><\Parent>
> <\MAP>
> 2016-08-17 21:13:42,084 INFO [main] org.apache.hadoop.hive.ql.exec.TableScanOperator:
Initializing operator TS[21]
> 2016-08-17 21:13:42,084 INFO [main] org.apache.hadoop.hive.ql.exec.mr.ExecMapper: Initializing
dummy operator
> 2016-08-17 21:13:42,086 INFO [main] org.apache.hadoop.hive.ql.exec.MapOperator: DESERIALIZE_ERRORS:0,
RECORDS_IN:0, 
> 2016-08-17 21:13:42,087 ERROR [main] org.apache.hadoop.hive.ql.exec.mr.ExecMapper: Hit
error while closing operators - failing tree
> 2016-08-17 21:13:42,088 WARN [main] org.apache.hadoop.mapred.YarnChild: Exception running
child : java.lang.RuntimeException: Hive Runtime Error while closing operators
> 	at org.apache.hadoop.hive.ql.exec.mr.ExecMapper.close(ExecMapper.java:207)
> 	at org.apache.hadoop.mapred.MapRunner.run(MapRunner.java:61)
> 	at org.apache.hadoop.mapred.MapTask.runOldMapper(MapTask.java:453)
> 	at org.apache.hadoop.mapred.MapTask.run(MapTask.java:343)
> 	at org.apache.hadoop.mapred.YarnChild$2.run(YarnChild.java:164)
> 	at java.security.AccessController.doPrivileged(Native Method)
> 	at javax.security.auth.Subject.doAs(Subject.java:422)
> 	at org.apache.hadoop.security.UserGroupInformation.doAs(UserGroupInformation.java:1657)
> 	at org.apache.hadoop.mapred.YarnChild.main(YarnChild.java:158)
> Caused by: java.lang.NullPointerException
> 	at org.apache.hadoop.hive.ql.exec.MapJoinOperator.closeOp(MapJoinOperator.java:474)
> 	at org.apache.hadoop.hive.ql.exec.Operator.close(Operator.java:682)
> 	at org.apache.hadoop.hive.ql.exec.Operator.close(Operator.java:696)
> 	at org.apache.hadoop.hive.ql.exec.Operator.close(Operator.java:696)
> 	at org.apache.hadoop.hive.ql.exec.mr.ExecMapper.close(ExecMapper.java:189)
> 	... 8 more
> {noformat}



--
This message was sent by Atlassian JIRA
(v6.3.15#6346)

Mime
View raw message