[CALCITE-2343] PushProjector with OVER expression causing infinite loop

• Type: Bug
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Fix Version/s: 1.20.0
• Labels: pull-request-available
• Assignee: Chunwei Lei
• Reporter: Laurent Goujon
• Created: 31/May/18 03:17
• Updated: 24/Jun/21 05:49
• Resolved: 17/Apr/19 03:53

Description

When applying the ProjectJoinTransposeRule on a project with a Rex expression containing a RexOver call (using HepPlanner), this might cause an infinite loop (and ultimately a StackOverflowError exception) as PushProjector identify the RexOver call as to be push down under the join, but doesn't not rewrite correctly the top Project expression.

Issue Links

• relates to: HIVE-25278 HiveProjectJoinTransposeRule may do invalid transformations with windowing expressions
• links to: GitHub Pull Request #713
• links to: GitHub Pull Request #1162