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