[
https://issues.apache.org/jira/browse/DRILL-774?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14002138#comment-14002138
]
Aman Sinha commented on DRILL-774:
----------------------------------
Could you provide the Explain plan for this query ? if it is using
HashAggregate, there is a chance it might be encountering an underlying issue
in hash table that is being fixed as part of DRILL-713, so we should test this
once that fix is in.
> 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)
