Zhiyong Liu created DRILL-774:
---------------------------------
Summary: verification fails for group-by
Key: DRILL-774
URL: https://issues.apache.org/jira/browse/DRILL-774
Project: Apache Drill
Issue Type: Bug
Components: Functions - Drill
Reporter: Zhiyong Liu
Datasources: TPCH (10MB), three-way split parquet files
git.commit.id.abbrev=70fab8c
git.commit.id=70fab8c968a6dc05471aa1f32009cd15945d4f3d
Verification fails for the following query:
2014-05-19 10:39:34 INFO QuerySubmitter:92 - Submitting query:
select l.l_partkey, count(*)
from lineitem l,
partsupp ps
where l.l_partkey = ps.ps_partkey
group by l.l_partkey
2014-05-19 10:39:35 INFO DrillTestBase:198 - Query submit end time: 2014/05/19
10:39:35.0035
2014-05-19 10:39:35 INFO DrillTestBase:199 - The execution time for the query:
1 seconds.
2014-05-19 10:39:35 INFO TestVerifier:203 - These rows are not expected:
2014-05-19 10:39:35 INFO TestVerifier:206 - 1245 11 : 1 time(s).
2014-05-19 10:39:35 INFO TestVerifier:206 - 1296 63 : 1 time(s).
2014-05-19 10:39:35 INFO TestVerifier:206 - 929 103 : 1 time(s).
2014-05-19 10:39:35 INFO TestVerifier:206 - 1245 117 : 1 time(s).
2014-05-19 10:39:35 INFO TestVerifier:206 - 1125 105 : 1 time(s).
2014-05-19 10:39:35 INFO TestVerifier:206 - 929 1 : 1 time(s).
2014-05-19 10:39:35 INFO TestVerifier:206 - 1251 96 : 1 time(s).
2014-05-19 10:39:35 INFO TestVerifier:213 - Total number of unexpected rows: 7
2014-05-19 10:39:35 INFO TestVerifier:217 - These rows are expected but are
not in result set:
2014-05-19 10:39:35 INFO TestVerifier:220 - 1125 140 : 1 time(s).
2014-05-19 10:39:35 INFO TestVerifier:220 - 929 104 : 1 time(s).
2014-05-19 10:39:35 INFO TestVerifier:220 - 1296 84 : 1 time(s).
2014-05-19 10:39:35 INFO TestVerifier:220 - 1245 128 : 1 time(s).
2014-05-19 10:39:35 INFO TestVerifier:220 - 1251 128 : 1 time(s).
2014-05-19 10:39:35 INFO TestVerifier:227 - Total number of expected but
missing: 5
--
This message was sent by Atlassian JIRA
(v6.2#6252)
