[ https://issues.apache.org/jira/browse/DRILL-616?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Parth Chandra updated DRILL-616: -------------------------------- Component/s: Query Planning & Optimization > TPCH: query 12 verification fails > --------------------------------- > > Key: DRILL-616 > URL: https://issues.apache.org/jira/browse/DRILL-616 > 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.l_shipmode, > sum(case > when o.o_orderpriority = '1-URGENT' > or o.o_orderpriority = '2-HIGH' > then 1 > else 0 > end) as high_line_count, > sum(case > when o.o_orderpriority <> '1-URGENT' > and o.o_orderpriority <> '2-HIGH' > then 1 > else 0 > end) as low_line_count > from > orders o, > lineitem l > where > o.o_orderkey = l.l_orderkey > and l.l_shipmode in ('TRUCK', 'REG AIR') > and l.l_commitdate < l.l_receiptdate > and l.l_shipdate < l.l_commitdate > and l.l_receiptdate >= date '1994-01-01' > and l.l_receiptdate < date '1994-01-01' + interval '1' year > group by > l.l_shipmode > order by > l.l_shipmode; > 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-05-01 10:38:18 INFO TestVerifier:192 - These rows are not expected: > > 2014-05-01 10:38:18 INFO TestVerifier:195 - TRUCK 14864 22054 : 1 > time(s). > 2014-05-01 10:38:18 INFO TestVerifier:195 - REG AIR 14968 22430 : 1 > time(s). > 2014-05-01 10:38:18 INFO TestVerifier:202 - Total number of unexpected rows: > 2 > 2014-05-01 10:38:18 INFO TestVerifier:206 - These rows are expected but are > not in result set: > 2014-05-01 10:38:18 INFO TestVerifier:209 - AIR 3078 4565 : 1 > time(s). > 2014-05-01 10:38:18 INFO TestVerifier:209 - MAIL 3204 4617 : 1 > time(s). > 2014-05-01 10:38:18 INFO TestVerifier:216 - Total number of expected but > missing: 2 -- This message was sent by Atlassian JIRA (v6.3.4#6332)