drill-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Zhiyong Liu (JIRA)" <j...@apache.org>
Subject [jira] [Updated] (DRILL-611) TPCH: query 05 verification fails
Date Thu, 01 May 2014 04:22:17 GMT

     [ https://issues.apache.org/jira/browse/DRILL-611?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]

Zhiyong Liu updated DRILL-611:
------------------------------

    Description: 
1. Set up drill test framework (see https://github.com/zhiyongliu/incubator-drill/tree/master/testing)
and generate TCP H dataset with a scale factor of about 500MB.
2. Query file (modified from original by drill dev, and further modified as follows):

select                                                                                   
                                       
  n.n_name,                                                                              
                                       
  sum(l.l_extendedprice * (1 - l.l_discount)) as revenue                                 
                                       

from
  customer c,
  orders o,  
  lineitem l,
  supplier s,
  nation n,  
  region r   

where
  c.c_custkey = o.o_custkey
  and l.l_orderkey = o.o_orderkey
  and l.l_suppkey = s.s_suppkey  
  and c.c_nationkey = s.s_nationkey
  and s.s_nationkey = n.n_nationkey
  and n.n_regionkey = r.r_regionkey
  and r.r_name = 'EUROPE'          
  and o.o_orderdate >= date '1997-01-01'
  and o.o_orderdate < date '1997-01-01' + interval '1' year
group by                                                   
  n.n_name                                                 

order by
  revenue desc

3. Drill build:
git.commit.id=1e0e4dfc96c8e7eb83659784dfbb85cd83d7d243

4. The baseline/expected results are generated via Oracle DB.
5. Run the above query in the test framework, with verification turned on.
6. Verification fails:

2014-04-30 14:48:28 INFO  TestVerifier:206 - These rows are expected but are not in result
set:
2014-04-30 14:48:28 INFO  TestVerifier:209 -    ROMANIA 23412645.1 : 1 time(s).          
     
2014-04-30 14:48:28 INFO  TestVerifier:209 -    GERMANY 29054886.4 : 1 time(s).          
     
2014-04-30 14:48:28 INFO  TestVerifier:209 -    RUSSIA  26653618.4 : 1 time(s).          
     
2014-04-30 14:48:28 INFO  TestVerifier:209 -    UNITED KINGDOM  23903443.3 : 1 time(s).  
     
2014-04-30 14:48:28 INFO  TestVerifier:209 -    FRANCE  24893950.8 : 1 time(s).          
     
2014-04-30 14:48:28 INFO  TestVerifier:216 - Total number of expected but missing: 5

  was:
1. Set up drill test framework (see https://github.com/zhiyongliu/incubator-drill/tree/master/testing)
2. Query file (modified from original by drill dev, and further modified as follows):

select                                                                                   
                                       
  n.n_name,                                                                              
                                       
  sum(l.l_extendedprice * (1 - l.l_discount)) as revenue                                 
                                       

from
  customer c,
  orders o,  
  lineitem l,
  supplier s,
  nation n,  
  region r   

where
  c.c_custkey = o.o_custkey
  and l.l_orderkey = o.o_orderkey
  and l.l_suppkey = s.s_suppkey  
  and c.c_nationkey = s.s_nationkey
  and s.s_nationkey = n.n_nationkey
  and n.n_regionkey = r.r_regionkey
  and r.r_name = 'EUROPE'          
  and o.o_orderdate >= date '1997-01-01'
  and o.o_orderdate < date '1997-01-01' + interval '1' year
group by                                                   
  n.n_name                                                 

order by
  revenue desc

3. Drill build:
git.commit.id=1e0e4dfc96c8e7eb83659784dfbb85cd83d7d243

4. The baseline/expected results are generated via Oracle DB.
5. Run the above query in the test framework, with verification turned on.
6. Verification fails:

2014-04-30 14:48:28 INFO  TestVerifier:206 - These rows are expected but are not in result
set:
2014-04-30 14:48:28 INFO  TestVerifier:209 -    ROMANIA 23412645.1 : 1 time(s).          
     
2014-04-30 14:48:28 INFO  TestVerifier:209 -    GERMANY 29054886.4 : 1 time(s).          
     
2014-04-30 14:48:28 INFO  TestVerifier:209 -    RUSSIA  26653618.4 : 1 time(s).          
     
2014-04-30 14:48:28 INFO  TestVerifier:209 -    UNITED KINGDOM  23903443.3 : 1 time(s).  
     
2014-04-30 14:48:28 INFO  TestVerifier:209 -    FRANCE  24893950.8 : 1 time(s).          
     
2014-04-30 14:48:28 INFO  TestVerifier:216 - Total number of expected but missing: 5


> TPCH: query 05 verification fails
> ---------------------------------
>
>                 Key: DRILL-611
>                 URL: https://issues.apache.org/jira/browse/DRILL-611
>             Project: Apache Drill
>          Issue Type: Bug
>            Reporter: Zhiyong Liu
>
> 1. Set up drill test framework (see https://github.com/zhiyongliu/incubator-drill/tree/master/testing)
and generate TCP H dataset with a scale factor of about 500MB.
> 2. Query file (modified from original by drill dev, and further modified as follows):
> select                                                                              
                                            
>   n.n_name,                                                                         
                                            
>   sum(l.l_extendedprice * (1 - l.l_discount)) as revenue                            
                                            
> from
>   customer c,
>   orders o,  
>   lineitem l,
>   supplier s,
>   nation n,  
>   region r   
> where
>   c.c_custkey = o.o_custkey
>   and l.l_orderkey = o.o_orderkey
>   and l.l_suppkey = s.s_suppkey  
>   and c.c_nationkey = s.s_nationkey
>   and s.s_nationkey = n.n_nationkey
>   and n.n_regionkey = r.r_regionkey
>   and r.r_name = 'EUROPE'          
>   and o.o_orderdate >= date '1997-01-01'
>   and o.o_orderdate < date '1997-01-01' + interval '1' year
> group by                                                   
>   n.n_name                                                 
> order by
>   revenue desc
> 3. Drill build:
> git.commit.id=1e0e4dfc96c8e7eb83659784dfbb85cd83d7d243
> 4. The baseline/expected results are generated via Oracle DB.
> 5. Run the above query in the test framework, with verification turned on.
> 6. Verification fails:
> 2014-04-30 14:48:28 INFO  TestVerifier:206 - These rows are expected but are not in result
set:
> 2014-04-30 14:48:28 INFO  TestVerifier:209 -    ROMANIA 23412645.1 : 1 time(s).     
          
> 2014-04-30 14:48:28 INFO  TestVerifier:209 -    GERMANY 29054886.4 : 1 time(s).     
          
> 2014-04-30 14:48:28 INFO  TestVerifier:209 -    RUSSIA  26653618.4 : 1 time(s).     
          
> 2014-04-30 14:48:28 INFO  TestVerifier:209 -    UNITED KINGDOM  23903443.3 : 1 time(s).
       
> 2014-04-30 14:48:28 INFO  TestVerifier:209 -    FRANCE  24893950.8 : 1 time(s).     
          
> 2014-04-30 14:48:28 INFO  TestVerifier:216 - Total number of expected but missing: 5



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

Mime
View raw message