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

ASF GitHub Bot commented on DRILL-3779:
---------------------------------------

Github user adeneche commented on the pull request:

    https://github.com/apache/drill/pull/160#issuecomment-141121314
  
    two small comments to address, apart from that LGTM, 
    +1


> NPE during mergeAndSpill operation of external sort
> ---------------------------------------------------
>
>                 Key: DRILL-3779
>                 URL: https://issues.apache.org/jira/browse/DRILL-3779
>             Project: Apache Drill
>          Issue Type: Bug
>          Components: Execution - Relational Operators
>    Affects Versions: 1.1.0
>            Reporter: Aman Sinha
>            Assignee: Deneche A. Hakim
>             Fix For: 1.2.0
>
>
> For a query of the following pattern: 
> {code}
> alter session set `planner.enable_hashjoin` = false;
> alter session set `planner.width.max_per_node` = 6;
> select 
>    t1.c1, t1.c2....t1.c50 
>   from t1 left outer join t2 on ..
>    left outer join t3  on ...
>    left outer join t4 on ...
>    left outer join t5 on ...
> where t2.col between t1.c1 and t1.c2
> {code}
> we get an NPE below.  The dataset is large so I cannot attach it here.  Will 
> try to get a repro with smaller data.  
> {code}
> java.sql.SQLException: SYSTEM ERROR: NullPointerException
> Fragment 5:0
> [Error Id: 3df8da3d-dee2-45d4-9a0a-abaa0ab3775e on se-node11.se.lab:31010]
>   (java.lang.NullPointerException) null
>     
> org.apache.drill.exec.physical.impl.xsort.ExternalSortBatch.getBufferSize():523
>     
> org.apache.drill.exec.physical.impl.xsort.ExternalSortBatch.mergeAndSpill():461
>     
> org.apache.drill.exec.physical.impl.xsort.ExternalSortBatch.innerNext():334
>     org.apache.drill.exec.record.AbstractRecordBatch.next():147
>     org.apache.drill.exec.record.AbstractRecordBatch.next():105
>     org.apache.drill.exec.record.AbstractRecordBatch.next():95
>     org.apache.drill.exec.record.AbstractSingleRecordBatch.innerNext():51
>     
> org.apache.drill.exec.physical.impl.svremover.RemovingRecordBatch.innerNext():92
>     org.apache.drill.exec.record.AbstractRecordBatch.next():147
>     org.apache.drill.exec.record.AbstractRecordBatch.next():105
>     org.apache.drill.exec.physical.impl.join.JoinStatus.nextLeft():127
>     org.apache.drill.exec.physical.impl.join.JoinStatus.ensureInitial():143
>     org.apache.drill.exec.physical.impl.join.MergeJoinBatch.innerNext():171
>     org.apache.drill.exec.record.AbstractRecordBatch.next():147
>     org.apache.drill.exec.record.AbstractRecordBatch.next():105
>     org.apache.drill.exec.record.AbstractRecordBatch.next():95
>     org.apache.drill.exec.record.AbstractSingleRecordBatch.innerNext():51
> {code}



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)

Reply via email to