impala-issues mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Anuj Phadke (JIRA)" <j...@apache.org>
Subject [jira] [Created] (IMPALA-5452) Nested subplans with non-trivial plan tree returns inconsistent results
Date Wed, 07 Jun 2017 18:40:18 GMT
Anuj Phadke created IMPALA-5452:
-----------------------------------

             Summary: Nested subplans with non-trivial plan tree returns inconsistent results
                 Key: IMPALA-5452
                 URL: https://issues.apache.org/jira/browse/IMPALA-5452
             Project: IMPALA
          Issue Type: Bug
          Components: Backend
    Affects Versions: Impala 2.9.0
            Reporter: Anuj Phadke


This particular query returned 18 rows consistently on running tests locally.

Query: select count(*)
from tpch_nested_parquet.customer c
inner join c.c_orders o
where c_custkey < 10 AND o.pos in
 (select lead(l.l_linenumber) over (order by l.pos)
  from o.o_lineitems l)
Query submitted at: 2017-06-07 11:20:39 (Coordinator: http://anuj-OptiPlex-9020:25000)
Query progress can be monitored at: http://anuj-OptiPlex-9020:25000/query_plan?query_id=a14392f4fe88572a:9cad5eb200000000
+----------+
| count(*) |
+----------+
| 18       |
+----------+

But here -
http://jenkins.impala.io:8080/job/gerrit-verify-dryrun/696/console
The same query returned 19 rows.

08:25:10 ] -- executing against localhost:21000
08:25:10 ] select count(*)
08:25:10 ] from tpch_nested_parquet.customer c
08:25:10 ] inner join c.c_orders o
08:25:10 ] where c_custkey < 10 AND o.pos in
08:25:10 ]   (select lead(l.l_linenumber) over (order by l.pos)
08:25:10 ]    from o.o_lineitems l);
08:25:10 ] 
08:25:10 ] MainThread: Comparing QueryTestResults (expected vs actual):
08:25:10 ] 18 != 19

This test was introduced as part of this commit -
https://gerrit.cloudera.org/#/c/916/4/testdata/workloads/functional-query/queries/QueryTest/subplans.test

As per this test, the query should have returned 14 rows. These tests have not been running
for a while and we failed to catch this.



--
This message was sent by Atlassian JIRA
(v6.3.15#6346)

Mime
View raw message