Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

Sign up for GitHub

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Jump to bottom

optimizer: Common Sub-Expression (CSE) #10812

Closed
TennyZhuang opened this issue Jul 7, 2023 · 1 comment · Fixed by #11356
Closed

optimizer: Common Sub-Expression (CSE) #10812

TennyZhuang opened this issue Jul 7, 2023 · 1 comment · Fixed by #11356
Assignees
@chenzl25
Labels
type/feature
Milestone
release-1.2

Comments

@TennyZhuang
Copy link
Contributor

Common Sub-Expression (CSE) optimization is a common optimization technique in query execution optimization.

In our usecase, it's very useful to extract the unnecessary duplicated cast(varchar) -> jsonb.

CSE is the reverse process of ProjectMerge, and we need to consider their conflicts.
@github-actions github-actions bot added this to the release-0.20 milestone Jul 7, 2023
@xxchan
Copy link
Member

xxchan commented Jul 12, 2023

Just a note: for CSE we need to consider purity 🤪 #9030.

@TennyZhuang TennyZhuang modified the milestones: release-1.0, release-1.1 Jul 12, 2023
@chenzl25 chenzl25 mentioned this issue Aug 1, 2023
Merged
8 tasks
@fuyufjh fuyufjh modified the milestones: release-1.1, release-1.2 Aug 8, 2023
@xiangjinwu xiangjinwu mentioned this issue Aug 18, 2023
Closed
@BugenZhao BugenZhao mentioned this issue Sep 27, 2023
Merged
4 tasks
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees

@chenzl25 chenzl25

Labels
type/feature
Projects
None yet
Milestone
release-1.2
Development

Successfully merging a pull request may close this issue.

feat(optimizer): support common sub-expression extraction risingwavelabs/risingwave
4 participants
@TennyZhuang @chenzl25 @fuyufjh @xxchan