[HIVE-25370] Improve SharedWorkOptimizer performance

• Type: Improvement
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Fix Version/s: 4.0.0-alpha-1
• Labels: pull-request-available
• Assignee: Zoltan Haindrich
• Reporter: Zoltan Haindrich
• Created: 22/Jul/21 13:51
• Updated: 17/Nov/22 08:47
• Resolved: 28/Jul/21 08:01

Description

for queries which are unioning ~800 constant rows the SWO is doing around n*n/2 operations trying to find 2 TS-es which could be merged

select constants
UNION ALL
...
UNION ALL
select constants

Issue Links

• links to: GitHub Pull Request #2536