[
https://issues.apache.org/jira/browse/ASTERIXDB-3543?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17922876#comment-17922876
]
ASF subversion and git services commented on ASTERIXDB-3543:
------------------------------------------------------------
Commit 61cd52011cb21713e4d0b79031d5e718d933d6c7 in asterixdb's branch
refs/heads/master from Vijay Sarathy
[ https://gitbox.apache.org/repos/asf?p=asterixdb.git;h=61cd52011c ]
[ASTERIXDB-3543][COMP] Do not inline expressions containing collection record
- user model changes: no
- storage format changes: no
- interface changes: no
Details:
Inlining expressions involving a collection's record
(e.g. field access $$col_rec.getField("x")) into the final
assign op (SELECT's assign op) can make query execution take
a long time especially if the records are not small. This is
because the $$col_rec has to be kept along in the frames from
the originating data-scan all the way through the operators
to the final assign op. This can prevent early projections
that aims to reduce the tuples size and increase the number
of tuples in a given frame.
This patch is to prevent inlining under certain conditions.
If the path from the source operator producing the expression
to the final assign op contains:
1. Operators with >= 2 inputs (e.g. JOINS).
2. ORDER-BY operator.
3. UNNEST operator.
Then we do not inline those expressions involving the data-scan
produced variables.
Ext-ref: MB-64252
Change-Id: Ia818f11e45bf66e3b4807938bfb635c70fa9c496
Reviewed-on: https://asterix-gerrit.ics.uci.edu/c/asterixdb/+/19351
Reviewed-by: Vijay Sarathy <[email protected]>
Reviewed-by: Ali Alsuliman <[email protected]>
Integration-Tests: Jenkins <[email protected]>
Tested-by: Jenkins <[email protected]>
> Investigate single reference inlining rule
> ------------------------------------------
>
> Key: ASTERIXDB-3543
> URL: https://issues.apache.org/jira/browse/ASTERIXDB-3543
> Project: Apache AsterixDB
> Issue Type: Task
> Components: COMP - Compiler
> Reporter: Vijay Sarathy
> Assignee: Vijay Sarathy
> Priority: Major
> Labels: triaged
>
> Query takes too long when field accesses get inlined, resulting in the
> document not being projected early at the beginning of the plan. Investigate
> this issue and suggest improvements as part of this task.
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
