Riza Suminto has posted comments on this change. ( 
http://gerrit.cloudera.org:8080/17252 )

Change subject: IMPALA-10647 Improve always-true min/max filter handling in 
coordinator
......................................................................


Patch Set 21:

(1 comment)

http://gerrit.cloudera.org:8080/#/c/17252/21/testdata/workloads/functional-query/queries/QueryTest/overlap_min_max_filters.test
File 
testdata/workloads/functional-query/queries/QueryTest/overlap_min_max_filters.test:

http://gerrit.cloudera.org:8080/#/c/17252/21/testdata/workloads/functional-query/queries/QueryTest/overlap_min_max_filters.test@285
PS21, Line 285: set minmax_filter_threshold=0.5;
              : select straight_join count(*) from
              : lineitem_orderkey_only a join [SHUFFLE] tpch_parquet.orders b
              : where a.l_orderkey = b.o_orderkey;
It looks like this test behave differently if filter arrived on time vs arrived 
late.
The jenkins failure seemingly because of both filters arrived late.
It is curious that late filter arrival lead to less row from 
lineitem_orderkey_only scan, not more.

In my local machine, if I add query option "set 
runtime_filter_wait_time_ms=5000;", this test pass.
But without setting wait time, an AlwaysFalse minmax filter seems to be 
broadcasted. This is a section of query profile where this test failed:


      lv-desktop:27000:
        Filter 1 arrival: 1s367ms
        Filter 0 arrival: 1s371ms
...
          Runtime filters: Not all filters arrived (arrived: [], missing [1, 
0]), waited for 785ms. Arrival delay: 1s000ms.
...
          Filter 1 (0):
             - Files processed: 0 (0)
             - Files rejected: 0 (0)
             - Files total: 0 (0)
             - InactiveTotalTime: 0.000ns
             - RowGroups processed: 0 (0)
             - RowGroups rejected: 0 (0)
             - RowGroups total: 1 (1)
             - Rows processed: 1.81M (1810767)
             - Rows rejected: 1.81M (1810767)
             - Rows total: 2.14M (2142543)
             - Splits processed: 0 (0)
             - Splits rejected: 0 (0)
             - Splits total: 0 (0)
             - TotalTime: 0.000ns



--
To view, visit http://gerrit.cloudera.org:8080/17252
To unsubscribe, visit http://gerrit.cloudera.org:8080/settings

Gerrit-Project: Impala-ASF
Gerrit-Branch: master
Gerrit-MessageType: comment
Gerrit-Change-Id: I326317833979efcbe02ce6c95ad80133dd5c7964
Gerrit-Change-Number: 17252
Gerrit-PatchSet: 21
Gerrit-Owner: Qifan Chen <[email protected]>
Gerrit-Reviewer: Fang-Yu Rao <[email protected]>
Gerrit-Reviewer: Impala Public Jenkins <[email protected]>
Gerrit-Reviewer: Joe McDonnell <[email protected]>
Gerrit-Reviewer: Qifan Chen <[email protected]>
Gerrit-Reviewer: Riza Suminto <[email protected]>
Gerrit-Reviewer: Wenzhe Zhou <[email protected]>
Gerrit-Comment-Date: Thu, 15 Apr 2021 21:07:29 +0000
Gerrit-HasComments: Yes

Reply via email to