You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@drill.apache.org by "Mehant Baid (JIRA)" <ji...@apache.org> on 2014/05/19 02:01:41 UTC

[jira] [Commented] (DRILL-716) verification fails for a join query

    [ https://issues.apache.org/jira/browse/DRILL-716?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14001269#comment-14001269 ] 

Mehant Baid commented on DRILL-716:
-----------------------------------

This is another symptom of the same underlying issue of DRILL-713. Should be fixed when DRILL-713 is fixed. 

> verification fails for a join query
> -----------------------------------
>
>                 Key: DRILL-716
>                 URL: https://issues.apache.org/jira/browse/DRILL-716
>             Project: Apache Drill
>          Issue Type: Bug
>            Reporter: Zhiyong Liu
>
> git.commit.id=e7a486d784c072458d44b7692ea0262da368f001
> 2014-05-13 11:33:13 INFO  QuerySubmitter:89 - Submitting query:                                          
> select count(*)                                                                                          
>   from (select c.c_custkey                                                                               
>         from customer c, orders o                                                                        
>         where c.c_custkey = o.o_custkey) as foo                                                          
> 2014-05-13 11:33:18 INFO  DrillTestBase:201 - Query submit end time: 2014/05/13 11:33:18.0018            
> 2014-05-13 11:33:18 INFO  DrillTestBase:202 - The execution time for the query: 5 seconds.               
> 2014-05-13 11:33:18 INFO  TestVerifier:203 - These rows are not expected:                                
> 2014-05-13 11:33:18 INFO  TestVerifier:206 -    14998 : 1 time(s).                                       
> 2014-05-13 11:33:18 INFO  TestVerifier:213 - Total number of unexpected rows: 1                          
> 2014-05-13 11:33:18 INFO  TestVerifier:217 - These rows are expected but are not in result set:          
> 2014-05-13 11:33:18 INFO  TestVerifier:220 -    15000 : 1 time(s).                                       
> 2014-05-13 11:33:18 INFO  TestVerifier:227 - Total number of expected but missing: 1   
> also, inconsistent resultset in split file tables.



--
This message was sent by Atlassian JIRA
(v6.2#6252)