drill-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Aman Sinha (JIRA)" <j...@apache.org>
Subject [jira] [Commented] (DRILL-774) verification fails for group-by
Date Mon, 19 May 2014 18:34:39 GMT

    [ 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)

Mime
View raw message