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