You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@doris.apache.org by GitBox <gi...@apache.org> on 2022/06/21 11:37:03 UTC
[GitHub] [doris] tianhui5 opened a new pull request, #10314: [Bug] Case clause is not supported for column in grouping set
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: commits-unsubscribe@doris.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For additional commands, e-mail: commits-help@doris.apache.org
[GitHub] [doris] github-actions[bot] commented on pull request #10314: [Bug] Case clause is not supported for column in grouping set
Posted by GitBox <gi...@apache.org>.
github-actions[bot] commented on PR #10314:
URL: https://github.com/apache/doris/pull/10314#issuecomment-1356910869
We're closing this PR because it hasn't been updated in a while.
This isn't a judgement on the merit of the PR in any way. It's just a way of keeping the PR queue manageable.
If you'd like to revive this PR, please reopen it and feel free a maintainer to remove the Stale tag!
--
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: commits-unsubscribe@doris.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For additional commands, e-mail: commits-help@doris.apache.org
[GitHub] [doris] github-actions[bot] closed pull request #10314: [Bug] Case clause is not supported for column in grouping set
Posted by GitBox <gi...@apache.org>.
github-actions[bot] closed pull request #10314: [Bug] Case clause is not supported for column in grouping set
URL: https://github.com/apache/doris/pull/10314
--
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: commits-unsubscribe@doris.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For additional commands, e-mail: commits-help@doris.apache.org