You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@drill.apache.org by "Parth Chandra (JIRA)" <ji...@apache.org> on 2015/04/20 20:05:59 UTC
[jira] [Updated] (DRILL-609) TPCH: query 01 verification fails
[ https://issues.apache.org/jira/browse/DRILL-609?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Parth Chandra updated DRILL-609:
--------------------------------
Component/s: Query Planning & Optimization
> TPCH: query 01 verification fails
> ---------------------------------
>
> Key: DRILL-609
> URL: https://issues.apache.org/jira/browse/DRILL-609
> Project: Apache Drill
> Issue Type: Bug
> Components: Query Planning & Optimization
> Reporter: Zhiyong Liu
> Priority: Blocker
> Fix For: 0.4.0
>
>
> 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
> l_returnflag,
> l_linestatus,
> sum(l_quantity) as sum_qty,
> sum(l_extendedprice) as sum_base_price,
> sum(l_extendedprice * (1 - l_discount)) as sum_disc_price,
> sum(l_extendedprice * (1 - l_discount) * (1 + l_tax)) as sum_charge,
> avg(l_quantity) as avg_qty,
> avg(l_extendedprice) as avg_price,
> avg(l_discount) as avg_disc,
> count(*) as count_order
> from
> lineitem
> where
> l_shipdate <= date '1998-12-01' - interval '120' day (3)
> group by
> l_returnflag,
> l_linestatus
> order by
> l_returnflag,
> l_linestatus
> 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:27:24 INFO TestVerifier:192 - These rows are not expected:
> 2014-04-30 14:27:24 INFO TestVerifier:195 - N F 499596.0 7.237821561700001E8 6.87811474102097E8 7.152735291765119E8 25.562627916496112 37032.99309250921 0.0 19544 : 1 time(s).
> 2014-04-30 14:27:24 INFO TestVerifier:195 - N O 3.6357561E7 5.271068187394886E10 5.007347520096913E10 5.2078457678915245E10 25.50090690001515 36970.3802709618 0.0 1425736 : 1 time(s).
> 2014-04-30 14:27:24 INFO TestVerifier:195 - A F 1.8865717E7 2.7356549949989704E10 2.598835690045046E10 2.7027321931296932E10 25.519179575692974 37004.03879606534 0.0 739276 : 1 time(s).
> 2014-04-30 14:27:24 INFO TestVerifier:195 - R F 1.8872497E7 2.734543103391961E10 2.5979800081985153E10 2.7018232810784813E10 25.51844400003786 36974.643676062755 0.0 739563 : 1 time(s).
> 2014-04-30 14:27:24 INFO TestVerifier:202 - Total number of unexpected rows: 4
> 2014-04-30 14:27:24 INFO TestVerifier:206 - These rows are expected but are not in result set:
> 2014-04-30 14:27:24 INFO TestVerifier:209 - R F 18872497 2.7345E+10 2.5980E+10 2.7018E+10 25.518444 36975.1205 .049998932 739563 : 1 time(s).
> 2014-04-30 14:27:24 INFO TestVerifier:209 - N F 499596 723782156 687811474 715273529 25.5626279 37033.4709 .049806079 19544 : 1 time(s).
> 2014-04-30 14:27:24 INFO TestVerifier:209 - N O 36723890 5.3242E+10 5.0579E+10 5.2604E+10 25.5009482 36971.3264 .050030831 1440099 : 1 time(s).
> 2014-04-30 14:27:24 INFO TestVerifier:209 - A F 18865717 2.7357E+10 2.5988E+10 2.7027E+10 25.5191796 37004.5152 .050007873 739276 : 1 time(s).
> 2014-04-30 14:27:24 INFO TestVerifier:216 - Total number of expected but missing: 4
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)