Wail Y. Alkowaileet created ASTERIXDB-3331:
----------------------------------------------
Summary: Columnar filter should not pushdown aggregate functions
Key: ASTERIXDB-3331
URL: https://issues.apache.org/jira/browse/ASTERIXDB-3331
Project: Apache AsterixDB
Issue Type: Bug
Components: COMP - Compiler
Affects Versions: 0.9.9
Reporter: Wail Y. Alkowaileet
Assignee: Wail Y. Alkowaileet
Fix For: 0.9.9
Query:
{noformat}SELECT VALUE d
FROM ColumnDataset d
WHERE EXISTS d.array{noformat}
Plan:
{noformat}distribute result [$$d] [cardinality: 0.0, op-cost: 0.0, total-cost:
0.0]
-- DISTRIBUTE_RESULT |PARTITIONED|
exchange [cardinality: 0.0, op-cost: 0.0, total-cost: 0.0]
-- ONE_TO_ONE_EXCHANGE |PARTITIONED|
select (neq(count($$d.getField(\"array\")), 0)) [cardinality: 0.0, op-cost:
0.0, total-cost: 0.0]
-- STREAM_SELECT |PARTITIONED|
project ([$$d]) [cardinality: 0.0, op-cost: 0.0, total-cost: 0.0]
-- STREAM_PROJECT |PARTITIONED|
exchange [cardinality: 0.0, op-cost: 0.0, total-cost: 0.0]
-- ONE_TO_ONE_EXCHANGE |PARTITIONED|
data-scan []<-[$$15, $$d] <- test.ColumnDataset filter on:
neq(count($$d.getField(\"array\")), 0) [cardinality: 0.0, op-cost: 0.0,
total-cost: 0.0]
-- DATASOURCE_SCAN |PARTITIONED|
exchange [cardinality: 0.0, op-cost: 0.0, total-cost: 0.0]
-- ONE_TO_ONE_EXCHANGE |PARTITIONED|
empty-tuple-source [cardinality: 0.0, op-cost: 0.0, total-cost:
0.0]
-- EMPTY_TUPLE_SOURCE |PARTITIONED| {noformat}
Filter *neq(count($$d.getField("array")), 0)* should not pushed to data-scan
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
