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

Aman Sinha commented on DRILL-938:
----------------------------------

I was able to reproduce the wrong result on SF1 scale factor , max width set to 
10.  The issue was with resizing of the hash table.  During resizing (which 
includes rehashing) the entries in the links vector were not set correctly if 
the hash chain spanned multiple batch holders.  The attached patch has the fix 
for this.   Note that I have tested it on SF1 scale factor only, not SF100.  

> Simplifed SF100 TPCH query returns incorrect results
> ----------------------------------------------------
>
>                 Key: DRILL-938
>                 URL: https://issues.apache.org/jira/browse/DRILL-938
>             Project: Apache Drill
>          Issue Type: Bug
>          Components: Execution - Operators
>            Reporter: Jacques Nadeau
>            Assignee: Aman Sinha
>            Priority: Critical
>             Fix For: 1.0.0-BETA1
>
>         Attachments: 
> 0001-Fix-DRILL-938-Set-the-links-entry-correctly-when-res.patch
>
>
> This simplified query is dropping records.  Should return 150M, returns 
> 146,485,463.
> {code}
> select
>  count(*) 
> from
>   customer c,
>   orders o
> where
>   c.c_custkey = o.o_custkey
> {code}



--
This message was sent by Atlassian JIRA
(v6.2#6252)

Reply via email to