tianhui5 opened a new pull request, #10314:
URL: https://github.com/apache/doris/pull/10314
# Proposed changes
Support 'case when' expression in group set clause.
## Problem Summary:
If there is 'case when' expression in column of group set, the plan of query
is not right. Because the RepeatNode can't recognize the expr.
For example, input a SQL like
`SELECT month, case when brand_code='1005' then 'mi' else 'others' end as
code, brand_name, sum(sales_num), index_type from ads_market_cmp_m GROUP BY
ROLLUP( brand_name, month, index_type, code);`
the query plan is:
` 1:REPEAT_NODE
repeat: repeat 4 lines [[], [2], [0, 2], [0, 2, 4], [0, 2, 4]] `
but not
` 1:REPEAT_NODE
|
repeat: repeat 4 lines [[], [2], [0, 2], [0, 2, 4], [0, 1, 2, 4]]`
## Checklist(Required)
1. Does it affect the original behavior: (No)
2. Has unit tests been added: (No)
3. Has document been added or modified: (No Need)
4. Does it need to update dependencies: (No)
5. Are there any changes that cannot be rolled back: (No)
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: [email protected]
For queries about this service, please contact Infrastructure at:
[email protected]
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
