[
https://issues.apache.org/jira/browse/ASTERIXDB-3328?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17796483#comment-17796483
]
ASF subversion and git services commented on ASTERIXDB-3328:
------------------------------------------------------------
Commit 18f750a6be57041bc2fa608652cc98c71c94efc7 in asterixdb's branch
refs/heads/master from Wail Alkowaileet
[ https://gitbox.apache.org/repos/asf?p=asterixdb.git;h=18f750a6be ]
[ASTERIXDB-3328][COMP] Preserve x-products of external datasets
- user model changes: no
- storage format changes: no
- interface changes: no
Details:
Cross-products of external datasets are eliminated
(incorrectly) by the compiler
Change-Id: I75fa9893a58daddb84c82bcb4b02e3cebc03e67b
Reviewed-on: https://asterix-gerrit.ics.uci.edu/c/asterixdb/+/17998
Integration-Tests: Jenkins <jenk...@fulliautomatix.ics.uci.edu>
Reviewed-by: Wail Alkowaileet <wael....@gmail.com>
Reviewed-by: Ali Alsuliman <ali.al.solai...@gmail.com>
Tested-by: Jenkins <jenk...@fulliautomatix.ics.uci.edu>
> Avoid removing cross-products in external data
> ----------------------------------------------
>
> Key: ASTERIXDB-3328
> URL: https://issues.apache.org/jira/browse/ASTERIXDB-3328
> 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 COUNT(*)
> FROM ExtOrders o1, ExtOrders o2, ExtOrders o3 {noformat}
> Plan:
> {noformat}
> distribute result [$$58] [cardinality: 0.0, op-cost: 0.0, total-cost: 0.0]
> -- DISTRIBUTE_RESULT |UNPARTITIONED|
> exchange [cardinality: 0.0, op-cost: 0.0, total-cost: 0.0]
> -- ONE_TO_ONE_EXCHANGE |UNPARTITIONED|
> project ([$$58]) [cardinality: 0.0, op-cost: 0.0, total-cost: 0.0]
> -- STREAM_PROJECT |UNPARTITIONED|
> assign [$$58] <- [{\"$1\": $$59}] [cardinality: 0.0, op-cost: 0.0,
> total-cost: 0.0]
> -- ASSIGN |UNPARTITIONED|
> aggregate [$$59] <- [agg-sql-sum($$60)] [cardinality: 0.0, op-cost:
> 0.0, total-cost: 0.0]
> -- AGGREGATE |UNPARTITIONED|
> exchange [cardinality: 0.0, op-cost: 0.0, total-cost: 0.0]
> -- RANDOM_MERGE_EXCHANGE |PARTITIONED|
> aggregate [$$60] <- [agg-sql-count(1)] [cardinality: 0.0,
> op-cost: 0.0, total-cost: 0.0]
> -- AGGREGATE |PARTITIONED|
> exchange [cardinality: 0.0, op-cost: 0.0, total-cost: 0.0]
> -- ONE_TO_ONE_EXCHANGE |PARTITIONED|
> data-scan []<-[$$o3] <- ShopALot.ExtOrders [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}
> The plan is clearly incorrect and the joins should not be removed
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
