[
https://issues.apache.org/jira/browse/DRILL-713?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13997297#comment-13997297
]
Steven Phillips commented on DRILL-713:
---------------------------------------
I have reproduced this problem. If I disable hash join, I get the correct
count. It's a bit strange though. If I leave out the joins, or just include one
of the join conditions, I get the correct count, but when I include both join
conditions, we seem to lose 2 rows.
> verification fails for JOIN ON clause
> -------------------------------------
>
> Key: DRILL-713
> URL: https://issues.apache.org/jira/browse/DRILL-713
> Project: Apache Drill
> Issue Type: Bug
> Reporter: Zhiyong Liu
>
> git.commit.id=e7a486d784c072458d44b7692ea0262da368f001
> 2014-05-13 11:21:01 INFO QuerySubmitter:89 - Submitting query:
>
> select count(*)
>
> from supplier s
>
> join lineitem l on s.s_suppkey = l.l_suppkey
>
> join orders o on o.o_orderkey = l.l_orderkey
>
> where l.l_shipdate between date '1995-01-01' and date '1995-12-31'
>
> 2014-05-13 11:21:12 INFO DrillTestBase:201 - Query submit end time:
> 2014/05/13 11:21:12.0012
> 2014-05-13 11:21:12 INFO DrillTestBase:202 - The execution time for the
> query: 10 seconds.
> 2014-05-13 11:21:12 INFO TestVerifier:203 - These rows are not expected:
>
> 2014-05-13 11:21:12 INFO TestVerifier:206 - 8769 : 1 time(s).
>
> 2014-05-13 11:21:12 INFO TestVerifier:213 - Total number of unexpected rows:
> 1
> 2014-05-13 11:21:12 INFO TestVerifier:217 - These rows are expected but are
> not in result set:
> 2014-05-13 11:21:12 INFO TestVerifier:220 - 8773 : 1 time(s).
>
> 2014-05-13 11:21:12 INFO TestVerifier:227 - Total number of expected but
> missing: 1
> Likewise for this query, which is supposed to return the same resultset:
> 2014-05-13 11:24:19 INFO QuerySubmitter:89 - Submitting query:
>
> select count(*)
>
> from supplier s, lineitem l, orders o
>
> where s.s_suppkey = l.l_suppkey
>
> and o.o_orderkey = l.l_orderkey
>
> and l.l_shipdate between date '1995-01-01' and date '1995-12-31'
>
> 2014-05-13 11:24:30 INFO DrillTestBase:201 - Query submit end time:
> 2014/05/13 11:24:30.0030
> 2014-05-13 11:24:30 INFO DrillTestBase:202 - The execution time for the
> query: 10 seconds.
> 2014-05-13 11:24:30 INFO TestVerifier:203 - These rows are not expected:
>
> 2014-05-13 11:24:30 INFO TestVerifier:206 - 8771 : 1 time(s).
>
> 2014-05-13 11:24:30 INFO TestVerifier:213 - Total number of unexpected rows:
> 1
> 2014-05-13 11:24:30 INFO TestVerifier:217 - These rows are expected but are
> not in result set:
> 2014-05-13 11:24:30 INFO TestVerifier:220 - 8773 : 1 time(s).
>
> 2014-05-13 11:24:30 INFO TestVerifier:227 - Total number of expected but
> missing: 1
> also, inconsistent resultset in split file tables.
--
This message was sent by Atlassian JIRA
(v6.2#6252)
