[
https://issues.apache.org/jira/browse/ASTERIXDB-3101?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17693309#comment-17693309
]
ASF subversion and git services commented on ASTERIXDB-3101:
------------------------------------------------------------
Commit 9b1fda772238e418b014be637ca183d50cffb558 in asterixdb's branch
refs/heads/master from Ali Alsuliman
[ https://gitbox.apache.org/repos/asf?p=asterixdb.git;h=9b1fda7722 ]
[ASTERIXDB-3101][COMP] Make sure PushFieldAccessRule returns true when fired
- user model changes: no
- storage format changes: no
- interface changes: no
Details:
If an assign operator has been moved next to the data
scan operator, return true since the plan has been changed.
Also, make sure to add all the skipped intermediate assigns
to the already compared set.
Change-Id: Ic7e622aa36373a11f10f95ab5d045d51a2c0479e
Reviewed-on: https://asterix-gerrit.ics.uci.edu/c/asterixdb/+/17246
Reviewed-by: Ali Alsuliman <[email protected]>
Tested-by: Michael Blow <[email protected]>
> Long query compilation due to pushing down assign operators unnecessarily
> -------------------------------------------------------------------------
>
> Key: ASTERIXDB-3101
> URL: https://issues.apache.org/jira/browse/ASTERIXDB-3101
> Project: Apache AsterixDB
> Issue Type: Bug
> Components: COMP - Compiler
> Affects Versions: 0.9.6
> Reporter: Ali Alsuliman
> Assignee: Ali Alsuliman
> Priority: Major
> Fix For: 0.9.7
>
>
> One of the things that PushFieldAccessRule attempts to do is push an assign
> operator down as close as possible to the respective data scan operator. In
> the case where all the operators below the assign are other assign operators
> and they are all just field accesses to the data scan, pushing down the
> assign through each individual operator is not necessary which was shown to
> be problematic when the SELECT statement has a large number of fields causing
> the compilation of the query to take eternity. Instead, the assign operator
> could skip the intermediate assign operators and be connected to the data
> scan.
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
