[
https://issues.apache.org/jira/browse/DRILL-774?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14002077#comment-14002077
]
Zhiyong Liu commented on DRILL-774:
-----------------------------------
I tend to believe that this failure may be of the same nature:
2014-05-19 10:51:35 INFO QuerySubmitter:92 - Submitting query:
select ps.ps_partkey, count(*)
from lineitem l,
partsupp ps
where l.l_partkey = ps.ps_partkey
group by ps.ps_partkey
2014-05-19 10:51:36 INFO DrillTestBase:198 - Query submit end time: 2014/05/19
10:51:36.0036
2014-05-19 10:51:36 INFO DrillTestBase:199 - The execution time for the query:
1 seconds.
2014-05-19 10:51:36 INFO TestVerifier:203 - These rows are not expected:
2014-05-19 10:51:36 INFO TestVerifier:206 - 1245 11 : 1 time(s).
2014-05-19 10:51:36 INFO TestVerifier:206 - 944 34 : 1 time(s).
2014-05-19 10:51:36 INFO TestVerifier:206 - 929 103 : 1 time(s).
2014-05-19 10:51:36 INFO TestVerifier:206 - 1245 117 : 1 time(s).
2014-05-19 10:51:36 INFO TestVerifier:206 - 580 72 : 1 time(s).
2014-05-19 10:51:36 INFO TestVerifier:206 - 1125 105 : 1 time(s).
2014-05-19 10:51:36 INFO TestVerifier:206 - 929 1 : 1 time(s).
2014-05-19 10:51:36 INFO TestVerifier:213 - Total number of unexpected rows: 7
2014-05-19 10:51:36 INFO TestVerifier:217 - These rows are expected but are
not in result set:
2014-05-19 10:51:36 INFO TestVerifier:220 - 1125 140 : 1 time(s).
2014-05-19 10:51:36 INFO TestVerifier:220 - 580 96 : 1 time(s).
2014-05-19 10:51:36 INFO TestVerifier:220 - 929 104 : 1 time(s).
2014-05-19 10:51:36 INFO TestVerifier:220 - 1245 128 : 1 time(s).
2014-05-19 10:51:36 INFO TestVerifier:220 - 944 136 : 1 time(s).
2014-05-19 10:51:36 INFO TestVerifier:227 - Total number of expected but
missing: 5
> 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)
