You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@drill.apache.org by "Aman Sinha (JIRA)" <ji...@apache.org> on 2014/06/09 21:17:03 UTC
[jira] [Commented] (DRILL-832) verification fails for hash join
[ https://issues.apache.org/jira/browse/DRILL-832?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14025586#comment-14025586 ]
Aman Sinha commented on DRILL-832:
----------------------------------
I don't see a bug. I ran the following 2 queries on the latest master branch and got the same results as Postgres:
select o.o_totalprice from customer c, orders o where c.c_custkey = o.o_custkey order by o.o_totalprice limit 20;
select o.o_totalprice from customer c, orders o where c.c_custkey = o.o_custkey order by o.o_totalprice desc limit 20;
Note that I added an Order-By and limit to the original query because otherwise it is difficult to verify the results. Please run the above queries to verify.
> verification fails for hash join
> --------------------------------
>
> Key: DRILL-832
> URL: https://issues.apache.org/jira/browse/DRILL-832
> Project: Apache Drill
> Issue Type: Bug
> Components: Execution - Operators
> Reporter: Zhiyong Liu
> Assignee: Aman Sinha
> Priority: Critical
>
> Datasources: TPCH (10MB), three-way split parquet files
> git.commit.id.abbrev=92408f1
> git.commit.id=92408f193043fa3049d114930a97ecf2332e08c0
> A large amount of discrepant data for the following query:
> 2014-05-23 14:44:27 INFO DrillTestBase:275 - Submitting query:
> /root/open-source-drill-test/testing/framework/resources/tpch-smoke/testcases/join10-hash.q : alter session set `planner.enable_mergejoin` = false
> 2014-05-23 14:44:27 INFO DrillTestBase:275 - Submitting query:
> /root/open-source-drill-test/testing/framework/resources/tpch-smoke/testcases/join10-hash.q :
> select o.O_TOTALPRICE
> from customer c, orders o
> where c.C_CUSTKEY = o.O_CUSTKEY
--
This message was sent by Atlassian JIRA
(v6.2#6252)