[ https://issues.apache.org/jira/browse/ASTERIXDB-3331?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Ian Maxon updated ASTERIXDB-3331: --------------------------------- Labels: triaged (was: ) > 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 > Priority: Major > Labels: triaged > 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)