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/19 20:00:46 UTC
[jira] [Commented] (DRILL-774) verification fails for group-by
[ 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)