[jira] [Commented] (DRILL-938) Simplifed SF100 TPCH query returns incorrect results

["Aman Sinha (JIRA)" <ji...@apache.org>]

    [ 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)