[MCOL-4004] Reduce computation complexity of group_concat() Created: 2020-05-15  Updated: 2024-01-04  Resolved: 2023-10-26

Status: Closed
Project: MariaDB ColumnStore
Component/s: ExeMgr
Affects Version/s: 1.5.3
Fix Version/s: N/A

Type: New Feature Priority: Major
Reporter: Roman Assignee: Todd Stoffel (Inactive)
Resolution: Fixed Votes: 0
Labels: None

Epic Link: ColumnStore Performance Improvements

 Description   

As of 1.5 group_concat tries to precisely calculate the length of a result string elements. This is waistfull thus we should employ an heuristic,e.g. all of the elements takes 75% of the maximum length for the datatype.
We can compare the resulting string length with the allowed maximum length in ::getResult(). The refactoring is partially done(for DECIMALS) in MCOL-641.
Given this approach the estimate should be also calculated only once given we know RowGroup size.


Generated at Thu Feb 08 02:47:03 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.