[
https://issues.apache.org/jira/browse/CALCITE-7338?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Zhen Chen resolved CALCITE-7338.
--------------------------------
Resolution: Fixed
> Window hints are not propagated to window rel nodes
> ---------------------------------------------------
>
> Key: CALCITE-7338
> URL: https://issues.apache.org/jira/browse/CALCITE-7338
> Project: Calcite
> Issue Type: Bug
> Components: core
> Affects Versions: 1.41.0
> Reporter: Yash Mayya
> Assignee: Zhen Chen
> Priority: Major
> Labels: pull-request-available
> Fix For: 1.42.0
>
>
> Window hints don't currently seem to be propagated to the window rel nodes.
> We're using hints in Apache Pinot's multi-stage query engine (which is built
> on top of Calcite), and while hints on joins, aggregates, table scans etc.
> work as expected, we've found that hints on windows are not propagating at
> all. IIUC, most other logical nodes are created in the SqlToRelConverter
> phase and hints are propagated to the appropriate rel node based on the hint
> strategy table
> [here|https://github.com/apache/calcite/blob/34989b0ed7793cedf713c2f159de6247a730458c/core/src/main/java/org/apache/calcite/sql2rel/SqlToRelConverter.java#L823-L842].
> However, logical window nodes are created after the SqlToRelConverter phase,
> by the
> [ProjectToWindowRule|https://github.com/apache/calcite/blob/f19e854c39e5a43aea2323e455229bd8dfc6dcdb/core/src/main/java/org/apache/calcite/rel/rules/ProjectToWindowRule.java#L75]
> planner rule - and it doesn’t look like there’s any logic there to preserve
> or propagate hints.
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
