You are viewing a plain text version of this content. The canonical link for it is here.
Posted to notifications@asterixdb.apache.org by "ASF subversion and git services (Jira)" <ji...@apache.org> on 2023/09/19 14:32:00 UTC

[jira] [Commented] (ASTERIXDB-3266) Avoid pushing SELECT for EVERY in columnar and external filters

    [ https://issues.apache.org/jira/browse/ASTERIXDB-3266?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17766819#comment-17766819 ] 

ASF subversion and git services commented on ASTERIXDB-3266:
------------------------------------------------------------

Commit 2e96b66091b4b1b6eb332f78c4f87e11f9b5f1a2 in asterixdb's branch refs/heads/master from Wail Alkowaileet
[ https://gitbox.apache.org/repos/asf?p=asterixdb.git;h=2e96b66091 ]

[ASTERIXDB-3266][COMP] Avoid pushing down the inner SELECT for EVERY

- user model changes: no
- storage format changes: no
- interface changes: no

Details:
Avoid pushing down the inner SELECT for EVERY
in columnar and external filters.

Change-Id: I3fd509897e4894c3c8ceeedd04695d07d53084f6
Reviewed-on: https://asterix-gerrit.ics.uci.edu/c/asterixdb/+/17784
Integration-Tests: Jenkins <je...@fulliautomatix.ics.uci.edu>
Tested-by: Jenkins <je...@fulliautomatix.ics.uci.edu>
Reviewed-by: Wail Alkowaileet <wa...@gmail.com>
Reviewed-by: Ali Alsuliman <al...@gmail.com>


> Avoid pushing SELECT for EVERY in columnar and external filters
> ---------------------------------------------------------------
>
>                 Key: ASTERIXDB-3266
>                 URL: https://issues.apache.org/jira/browse/ASTERIXDB-3266
>             Project: Apache AsterixDB
>          Issue Type: Bug
>          Components: COMP - Compiler
>    Affects Versions: 0.9.9
>            Reporter: Wail Y. Alkowaileet
>            Assignee: Wail Y. Alkowaileet
>            Priority: Major
>             Fix For: 0.9.9
>
>
> SELECT for EVERY should not be pushed as it gives incorrect result.
> QUERY:
> {noformat}
> SELECT VALUE r
> FROM reviewsWithDynamicPrefixes r
> WHERE customer_id NOT IN [5]; {noformat}
>  
> PLAN:
> {noformat}
> distribute result [$$r] [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|
>     project ([$$r]) [cardinality: 0.0, op-cost: 0.0, total-cost: 0.0]
>     -- STREAM_PROJECT  |PARTITIONED|
>       select ($$18) [cardinality: 0.0, op-cost: 0.0, total-cost: 0.0]
>       -- STREAM_SELECT  |PARTITIONED|
>         project ([$$r, $$18]) [cardinality: 0.0, op-cost: 0.0, total-cost: 0.0]
>         -- STREAM_PROJECT  |PARTITIONED|
>           subplan {
>                     aggregate [$$18] <- [empty-stream()] [cardinality: 0.0, op-cost: 0.0, total-cost: 0.0]
>                     -- AGGREGATE  |LOCAL|
>                       select (not(if-missing-or-null(neq($$19, 5), false))) [cardinality: 0.0, op-cost: 0.0, total-cost: 0.0]
>                       -- STREAM_SELECT  |LOCAL|
>                         nested tuple source [cardinality: 0.0, op-cost: 0.0, total-cost: 0.0]
>                         -- NESTED_TUPLE_SOURCE  |LOCAL|
>                  } [cardinality: 0.0, op-cost: 0.0, total-cost: 0.0]
>           -- SUBPLAN  |PARTITIONED|
>             assign [$$19] <- [$$r.getField("customer_id")] [cardinality: 0.0, op-cost: 0.0, total-cost: 0.0]
>             -- ASSIGN  |PARTITIONED|
>               exchange [cardinality: 0.0, op-cost: 0.0, total-cost: 0.0]
>               -- ONE_TO_ONE_EXCHANGE  |PARTITIONED|
>                 data-scan []<-[$$r] <- Default.reviewsWithDynamicPrefixes prefix-filter on: not(if-missing-or-null(neq($$r.getField("customer_id"), 5), false)) [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}



--
This message was sent by Atlassian Jira
(v8.20.10#820010)