Zhiyong Liu created DRILL-775:
---------------------------------
Summary: verification fails for select count(distinct l_orderkey)
from lineitem group by l_partkey
Key: DRILL-775
URL: https://issues.apache.org/jira/browse/DRILL-775
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 11:01:23 INFO QuerySubmitter:92 - Submitting query:
select count(distinct l_orderkey) from lineitem group by l_partkey
2014-05-19 11:01:23 INFO DrillTestBase:198 - Query submit end time: 2014/05/19
11:01:23.0023
2014-05-19 11:01:23 INFO DrillTestBase:199 - The execution time for the query:
0 seconds.
2014-05-19 11:01:23 INFO TestVerifier:203 - These rows are not expected:
2014-05-19 11:01:23 INFO TestVerifier:206 - 2 : 1 time(s).
2014-05-19 11:01:23 INFO TestVerifier:206 - 1 : 1 time(s).
2014-05-19 11:01:23 INFO TestVerifier:206 - 30 : 1 time(s).
2014-05-19 11:01:23 INFO TestVerifier:206 - 25 : 1 time(s).
2014-05-19 11:01:23 INFO TestVerifier:213 - Total number of unexpected rows: 4
2014-05-19 11:01:23 INFO TestVerifier:217 - These rows are expected but are
not in result set:
2014-05-19 11:01:23 INFO TestVerifier:220 - 25 : 92 time(s).
2014-05-19 11:01:23 INFO TestVerifier:220 - 26 : 116 time(s).
2014-05-19 11:01:23 INFO TestVerifier:220 - 30 : 138 time(s).
2014-05-19 11:01:23 INFO TestVerifier:220 - 32 : 127 time(s).
2014-05-19 11:01:23 INFO TestVerifier:227 - Total number of expected but
missing: 4
--
This message was sent by Atlassian JIRA
(v6.2#6252)
