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/01/30 03:27:00 UTC
[jira] [Commented] (ASTERIXDB-3075) Query plan has cyclic dependency among plan activities
[ https://issues.apache.org/jira/browse/ASTERIXDB-3075?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17681859#comment-17681859 ]
ASF subversion and git services commented on ASTERIXDB-3075:
------------------------------------------------------------
Commit f88ee76e089bc9f04edf8b2e0e7be63bfe80b0ca in asterixdb's branch refs/heads/master from Ali Alsuliman
[ https://gitbox.apache.org/repos/asf?p=asterixdb.git;h=f88ee76e08 ]
[ASTERIXDB-3075][COMP] Fix ExtractCommonOperatorsRule producing invalid plan
- user model changes: no
- storage format changes: no
- interface changes: no
Details:
Reset the states of the variables used for calculating
the query plan cluster of activiites after each modification
to the plan.
Change-Id: If7be34f4262ea9f52fc9a40526909c0afb9091f0
Reviewed-on: https://asterix-gerrit.ics.uci.edu/c/asterixdb/+/17227
Reviewed-by: Ali Alsuliman <al...@gmail.com>
Reviewed-by: Wail Alkowaileet <wa...@gmail.com>
Tested-by: Jenkins <je...@fulliautomatix.ics.uci.edu>
Reviewed-on: https://asterix-gerrit.ics.uci.edu/c/asterixdb/+/17330
Reviewed-by: Michael Blow <mb...@apache.org>
Tested-by: Michael Blow <mb...@apache.org>
> Query plan has cyclic dependency among plan activities
> ------------------------------------------------------
>
> Key: ASTERIXDB-3075
> URL: https://issues.apache.org/jira/browse/ASTERIXDB-3075
> Project: Apache AsterixDB
> Issue Type: Bug
> Components: COMP - Compiler
> Affects Versions: 0.9.3
> Reporter: Ali Alsuliman
> Assignee: Ali Alsuliman
> Priority: Major
> Fix For: 0.9.7
>
>
> The plan for the below query has cyclic dependency among activities which causes a SO exception in Hyracks when trying to schedule the activities of the plan.
> {code:java}
> LET dv_name = ["test2", "test1"], ds_name = ["ds2", "ds1"], syn_name = [ "syn2", "syn1" ],
> synonym_names = (SELECT s.SynonymName, s.ObjectName
> FROM Metadata.`Synonym` s, syn_name
> WHERE s.SynonymName = syn_name),
> dataset_ds_dv_names = (SELECT d.DatasetName, d.DataverseName
> FROM Metadata.`Dataset` d, (SELECT * FROM ds_name, dv_name) AS ds_dv_names
> WHERE d.DatasetName = ds_dv_names.ds_name AND d.DataverseName = ds_dv_names.dv_name),
> dataset_dv_ds_names = (SELECT d.DatasetName, d.DataverseName
> FROM Metadata.`Dataset` d, (SELECT * FROM dv_name, ds_name) AS dv_ds_names
> WHERE d.DatasetName = dv_ds_names.ds_name AND d.DataverseName = dv_ds_names.dv_name),
> left_branch = (SELECT s.SynonymName, s.DataverseName, s.ObjectName
> FROM Metadata.`Synonym` s LEFT OUTER JOIN dataset_dv_ds_names
> ON dataset_dv_ds_names.DatasetName = s.ObjectName
> ORDER BY s.DataverseName, s.SynonymName),
> right_branch = (SELECT synonym_names.SynonymName
> FROM synonym_names LEFT OUTER JOIN dataset_ds_dv_names
> ON dataset_ds_dv_names.DatasetName = synonym_names.ObjectName)
> FROM left_branch lb LEFT OUTER JOIN right_branch rb
> ON lb.ObjectName = rb.SynonymName
> SELECT lb.DataverseName, lb.SynonymName
> ORDER BY lb.DataverseName, lb.SynonymName; {code}
> ExtractCommonOperatorsRule causes the issue when it extracts common segments of the plan and introduces replicate operators.
--
This message was sent by Atlassian Jira
(v8.20.10#820010)