asterixdb-notifications mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "ASF subversion and git services (JIRA)" <j...@apache.org>
Subject [jira] [Commented] (ASTERIXDB-2221) EquiJoin condition propagation for constant values
Date Sat, 06 Jan 2018 01:10:00 GMT

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

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

Commit 333e38ef1293227c0bf14ed03d910586267b1b73 in asterixdb's branch refs/heads/master from
[~imaxon]
[ https://git-wip-us.apache.org/repos/asf?p=asterixdb.git;h=333e38e ]

[ASTERIXDB-2221] Fix source LICENSE file

Change-Id: I51b605ff12eaf9a8b9133166cfb56e968f683df6
Reviewed-on: https://asterix-gerrit.ics.uci.edu/2260
Sonar-Qube: Jenkins <jenkins@fulliautomatix.ics.uci.edu>
Integration-Tests: Jenkins <jenkins@fulliautomatix.ics.uci.edu>
Reviewed-by: Michael Blow <mblow@apache.org>
Tested-by: Jenkins <jenkins@fulliautomatix.ics.uci.edu>


> EquiJoin condition propagation for constant values
> --------------------------------------------------
>
>                 Key: ASTERIXDB-2221
>                 URL: https://issues.apache.org/jira/browse/ASTERIXDB-2221
>             Project: Apache AsterixDB
>          Issue Type: Improvement
>            Reporter: Wail Alkowaileet
>
> When EquiJoin condition: t1.a=t2.a AND t.a = CONSTANT
> The filtration only applied on t1.a but not t2.a
> Query:
> {noformat}
> SELECT t.text as t1, te.text as t2
> FROM Tweets as t, TweetsExt as te
> WHERE t.a = te.a and t.a = "10"
> {noformat}
> Plan:
> {noformat}
> distribute result [$$28]
> -- DISTRIBUTE_RESULT  |PARTITIONED|
>   exchange
>   -- ONE_TO_ONE_EXCHANGE  |PARTITIONED|
>     project ([$$28])
>     -- STREAM_PROJECT  |PARTITIONED|
>       assign [$$28] <- [{"t1": $$32, "t2": $$33}]
>       -- ASSIGN  |PARTITIONED|
>         project ([$$32, $$33])
>         -- STREAM_PROJECT  |PARTITIONED|
>           exchange
>           -- ONE_TO_ONE_EXCHANGE  |PARTITIONED|
>             join (eq($$29, $$31))
>             -- HYBRID_HASH_JOIN [$$29][$$31]  |PARTITIONED|
>               exchange
>               -- HASH_PARTITION_EXCHANGE [$$29]  |PARTITIONED|
>                 select (eq($$29, "10"))
>                 -- STREAM_SELECT  |PARTITIONED|
>                   project ([$$32, $$29])
>                   -- STREAM_PROJECT  |PARTITIONED|
>                     assign [$$32, $$29] <- [$$t.getField("text"), $$t.getField("a")]
>                     -- ASSIGN  |PARTITIONED|
>                       project ([$$t])
>                       -- STREAM_PROJECT  |PARTITIONED|
>                         exchange
>                         -- ONE_TO_ONE_EXCHANGE  |PARTITIONED|
>                           data-scan []<-[$$30, $$t] <- TwitterDataverse.Tweets
>                           -- DATASOURCE_SCAN  |PARTITIONED|
>                             exchange
>                             -- ONE_TO_ONE_EXCHANGE  |PARTITIONED|
>                               empty-tuple-source
>                               -- EMPTY_TUPLE_SOURCE  |PARTITIONED|
>               exchange
>               -- HASH_PARTITION_EXCHANGE [$$31]  |PARTITIONED|
>                 project ([$$33, $$31])
>                 -- STREAM_PROJECT  |PARTITIONED|
>                   assign [$$33, $$31] <- [$$te.getField("text"), $$te.getField("a")]
>                   -- ASSIGN  |PARTITIONED|
>                     exchange
>                     -- ONE_TO_ONE_EXCHANGE  |PARTITIONED|
>                       data-scan []<-[$$te] <- TwitterDataverse.TweetsExt
>                       -- DATASOURCE_SCAN  |PARTITIONED|
>                         exchange
>                         -- ONE_TO_ONE_EXCHANGE  |PARTITIONED|
>                           empty-tuple-source
>                           -- EMPTY_TUPLE_SOURCE  |PARTITIONED|
> {noformat}



--
This message was sent by Atlassian JIRA
(v6.4.14#64029)

Mime
View raw message