You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@drill.apache.org by "Zhiyong Liu (JIRA)" <ji...@apache.org> on 2014/05/13 20:28:15 UTC
[jira] [Created] (DRILL-713) verification fails for JOIN ON clause
Zhiyong Liu created DRILL-713:
---------------------------------
Summary: 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)