[
https://issues.apache.org/jira/browse/FLINK-24610?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17434275#comment-17434275
]
Lyn Zhang edited comment on FLINK-24610 at 10/27/21, 2:33 AM:
--------------------------------------------------------------
[~jark] Please help to review this issue when you are free
was (Author: zicat):
[~jark] Please help to review this issue if you are free
> Flink projection common expression elimination
> ----------------------------------------------
>
> Key: FLINK-24610
> URL: https://issues.apache.org/jira/browse/FLINK-24610
> Project: Flink
> Issue Type: Improvement
> Components: Table SQL / Planner
> Reporter: Lyn Zhang
> Priority: Major
> Labels: pull-request-available
>
> Flink sql projection not support reusing common expression in code generator.
> For example the sql: SELECT split(a, '__'_)[1], split(a, '__'_)[2] FROM
> table.The function split(a, '_') will be invoked 2 times per row data.
> We can use CalcProgram.getExprList to generator each expression and
> CalcProgram.getProjectList to eliminate common expression.
--
This message was sent by Atlassian Jira
(v8.3.4#803005)
