Re: [PR] [CALCITE-6162] Add rule(s) to remove joins with constant single tuple… [calcite]

2024-01-17 Thread via GitHub
mihaibudiu merged PR #3597: URL: https://github.com/apache/calcite/pull/3597 -- 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:

Re: [PR] [CALCITE-6162] Add rule(s) to remove joins with constant single tuple… [calcite]

2024-01-16 Thread via GitHub
HanumathRao commented on PR #3597: URL: https://github.com/apache/calcite/pull/3597#issuecomment-1894877595 > I have no further comments. Please squash the commits so we can merge this PR. Thank you for the improvements! Done. Thanks for review. -- This is an automated message

Re: [PR] [CALCITE-6162] Add rule(s) to remove joins with constant single tuple… [calcite]

2024-01-16 Thread via GitHub
mihaibudiu commented on PR #3597: URL: https://github.com/apache/calcite/pull/3597#issuecomment-1894661539 I have no further comments. Please squash the commits so we can merge this PR. Thank you for the improvements! -- This is an automated message from the Apache Git Service. To

Re: [PR] [CALCITE-6162] Add rule(s) to remove joins with constant single tuple… [calcite]

2024-01-15 Thread via GitHub
HanumathRao commented on PR #3597: URL: https://github.com/apache/calcite/pull/3597#issuecomment-1893066965 > I have approved, but I still made a few small suggestions. It looks like the CI is unhappy. Thanks. I am not sure why only PR runs are showing this issue. The tests executed

Re: [PR] [CALCITE-6162] Add rule(s) to remove joins with constant single tuple… [calcite]

2024-01-15 Thread via GitHub
sonarcloud[bot] commented on PR #3597: URL: https://github.com/apache/calcite/pull/3597#issuecomment-1893065574 ## [![Quality Gate Passed](https://sonarsource.github.io/sonarcloud-github-static-resources/v2/checks/QualityGateBadge/qg-passed-20px.png 'Quality Gate

Re: [PR] [CALCITE-6162] Add rule(s) to remove joins with constant single tuple… [calcite]

2024-01-15 Thread via GitHub
mihaibudiu commented on PR #3597: URL: https://github.com/apache/calcite/pull/3597#issuecomment-1892660142 I have approved, but I still made a few small suggestions. It looks like the CI is unhappy. -- This is an automated message from the Apache Git Service. To respond to the message,

Re: [PR] [CALCITE-6162] Add rule(s) to remove joins with constant single tuple… [calcite]

2024-01-15 Thread via GitHub
mihaibudiu commented on code in PR #3597: URL: https://github.com/apache/calcite/pull/3597#discussion_r1452675906 ## core/src/main/java/org/apache/calcite/rel/rules/SingleValuesOptimizationRules.java: ## @@ -0,0 +1,374 @@ +/* + * Licensed to the Apache Software Foundation (ASF)

Re: [PR] [CALCITE-6162] Add rule(s) to remove joins with constant single tuple… [calcite]

2024-01-14 Thread via GitHub
HanumathRao commented on PR #3597: URL: https://github.com/apache/calcite/pull/3597#issuecomment-1891083336 > The code looks pretty good, my comments are about readability mostly. I am not familiar with this part of the codebase; perhaps a more experienced reviewer would understand faster.

Re: [PR] [CALCITE-6162] Add rule(s) to remove joins with constant single tuple… [calcite]

2024-01-14 Thread via GitHub
HanumathRao commented on PR #3597: URL: https://github.com/apache/calcite/pull/3597#issuecomment-1891082558 Not sure why the tests are showing failed in the PR but all of them are successful on the branch commit. https://github.com/HanumathRao/calcite/commits/CALCITE-6162/, build run

Re: [PR] [CALCITE-6162] Add rule(s) to remove joins with constant single tuple… [calcite]

2024-01-14 Thread via GitHub
HanumathRao commented on code in PR #3597: URL: https://github.com/apache/calcite/pull/3597#discussion_r1451805261 ## core/src/main/java/org/apache/calcite/rel/rules/SingleValuesOptimizationRules.java: ## @@ -0,0 +1,374 @@ +/* + * Licensed to the Apache Software Foundation

Re: [PR] [CALCITE-6162] Add rule(s) to remove joins with constant single tuple… [calcite]

2024-01-14 Thread via GitHub
sonarcloud[bot] commented on PR #3597: URL: https://github.com/apache/calcite/pull/3597#issuecomment-1891068012 ## [![Quality Gate Passed](https://sonarsource.github.io/sonarcloud-github-static-resources/v2/checks/QualityGateBadge/qg-passed-20px.png 'Quality Gate

Re: [PR] [CALCITE-6162] Add rule(s) to remove joins with constant single tuple… [calcite]

2024-01-14 Thread via GitHub
HanumathRao commented on code in PR #3597: URL: https://github.com/apache/calcite/pull/3597#discussion_r1451798326 ## core/src/main/java/org/apache/calcite/rel/rules/SingleValuesOptimizationRules.java: ## @@ -0,0 +1,374 @@ +/* + * Licensed to the Apache Software Foundation

Re: [PR] [CALCITE-6162] Add rule(s) to remove joins with constant single tuple… [calcite]

2024-01-14 Thread via GitHub
HanumathRao commented on code in PR #3597: URL: https://github.com/apache/calcite/pull/3597#discussion_r1451798161 ## core/src/test/java/org/apache/calcite/test/JdbcTest.java: ## @@ -2973,27 +2973,29 @@ void testInnerJoinValues(String format) { switch (format) { case

Re: [PR] [CALCITE-6162] Add rule(s) to remove joins with constant single tuple… [calcite]

2024-01-10 Thread via GitHub
mihaibudiu commented on code in PR #3597: URL: https://github.com/apache/calcite/pull/3597#discussion_r1447886735 ## core/src/main/java/org/apache/calcite/rel/rules/SingleValuesOptimizationRules.java: ## @@ -0,0 +1,374 @@ +/* + * Licensed to the Apache Software Foundation (ASF)

Re: [PR] [CALCITE-6162] Add rule(s) to remove joins with constant single tuple… [calcite]

2024-01-10 Thread via GitHub
HanumathRao commented on PR #3597: URL: https://github.com/apache/calcite/pull/3597#issuecomment-1885306396 @mihaibudiu Thanks for the suggestion. I have added the javadoc comments wherever I think are needed for clarity. Regarding the comments for the rules, I have already added comments

Re: [PR] [CALCITE-6162] Add rule(s) to remove joins with constant single tuple… [calcite]

2024-01-09 Thread via GitHub
mihaibudiu commented on code in PR #3597: URL: https://github.com/apache/calcite/pull/3597#discussion_r1446463682 ## core/src/main/java/org/apache/calcite/rel/rules/SingleValueOptimizationRules.java: ## @@ -0,0 +1,329 @@ +/* + * Licensed to the Apache Software Foundation (ASF)

Re: [PR] [CALCITE-6162] Add rule(s) to remove joins with constant single tuple… [calcite]

2024-01-09 Thread via GitHub
HanumathRao commented on code in PR #3597: URL: https://github.com/apache/calcite/pull/3597#discussion_r1446459398 ## core/src/main/java/org/apache/calcite/rel/rules/SingleValueOptimizationRules.java: ## @@ -0,0 +1,329 @@ +/* + * Licensed to the Apache Software Foundation (ASF)

Re: [PR] [CALCITE-6162] Add rule(s) to remove joins with constant single tuple… [calcite]

2024-01-08 Thread via GitHub
mihaibudiu commented on code in PR #3597: URL: https://github.com/apache/calcite/pull/3597#discussion_r1445394313 ## core/src/main/java/org/apache/calcite/rel/rules/SingleValueOptimizationRules.java: ## @@ -0,0 +1,329 @@ +/* + * Licensed to the Apache Software Foundation (ASF)

Re: [PR] [CALCITE-6162] Add rule(s) to remove joins with constant single tuple… [calcite]

2024-01-08 Thread via GitHub
HanumathRao commented on code in PR #3597: URL: https://github.com/apache/calcite/pull/3597#discussion_r1445132866 ## core/src/main/java/org/apache/calcite/rel/rules/SingleValueOptimizationRules.java: ## @@ -0,0 +1,361 @@ +/* + * Licensed to the Apache Software Foundation (ASF)

Re: [PR] [CALCITE-6162] Add rule(s) to remove joins with constant single tuple… [calcite]

2024-01-08 Thread via GitHub
HanumathRao commented on code in PR #3597: URL: https://github.com/apache/calcite/pull/3597#discussion_r1445133506 ## core/src/main/java/org/apache/calcite/rel/rules/SingleValueOptimizationRules.java: ## @@ -0,0 +1,361 @@ +/* + * Licensed to the Apache Software Foundation (ASF)

Re: [PR] [CALCITE-6162] Add rule(s) to remove joins with constant single tuple… [calcite]

2024-01-08 Thread via GitHub
HanumathRao commented on code in PR #3597: URL: https://github.com/apache/calcite/pull/3597#discussion_r1445131777 ## core/src/main/java/org/apache/calcite/rel/rules/SingleValueOptimizationRules.java: ## @@ -0,0 +1,361 @@ +/* + * Licensed to the Apache Software Foundation (ASF)

Re: [PR] [CALCITE-6162] Add rule(s) to remove joins with constant single tuple… [calcite]

2024-01-08 Thread via GitHub
HanumathRao commented on code in PR #3597: URL: https://github.com/apache/calcite/pull/3597#discussion_r1445130564 ## core/src/test/java/org/apache/calcite/test/RelOptRulesTest.java: ## @@ -4177,6 +4178,109 @@ RelOptFixture checkDynamicFunctions(boolean

Re: [PR] [CALCITE-6162] Add rule(s) to remove joins with constant single tuple… [calcite]

2024-01-03 Thread via GitHub
macroguo-ghy commented on code in PR #3597: URL: https://github.com/apache/calcite/pull/3597#discussion_r1441266692 ## core/src/main/java/org/apache/calcite/rel/rules/SingleValueOptimizationRules.java: ## @@ -0,0 +1,361 @@ +/* + * Licensed to the Apache Software Foundation

Re: [PR] [CALCITE-6162] Add rule(s) to remove joins with constant single tuple… [calcite]

2023-12-30 Thread via GitHub
JiajunBernoulli commented on code in PR #3597: URL: https://github.com/apache/calcite/pull/3597#discussion_r1438824373 ## core/src/main/java/org/apache/calcite/rel/rules/SingleValueOptimizationRules.java: ## @@ -0,0 +1,361 @@ +/* + * Licensed to the Apache Software Foundation

Re: [PR] [CALCITE-6162] Add rule(s) to remove joins with constant single tuple… [calcite]

2023-12-29 Thread via GitHub
mihaibudiu commented on code in PR #3597: URL: https://github.com/apache/calcite/pull/3597#discussion_r1438438843 ## core/src/test/java/org/apache/calcite/test/RelOptRulesTest.java: ## @@ -4177,6 +4178,109 @@ RelOptFixture checkDynamicFunctions(boolean

Re: [PR] [CALCITE-6162] Add rule(s) to remove joins with constant single tuple… [calcite]

2023-12-29 Thread via GitHub
HanumathRao commented on code in PR #3597: URL: https://github.com/apache/calcite/pull/3597#discussion_r1438278222 ## core/src/test/java/org/apache/calcite/test/RelOptRulesTest.java: ## @@ -4177,6 +4178,109 @@ RelOptFixture checkDynamicFunctions(boolean

Re: [PR] [CALCITE-6162] Add rule(s) to remove joins with constant single tuple… [calcite]

2023-12-29 Thread via GitHub
sonarcloud[bot] commented on PR #3597: URL: https://github.com/apache/calcite/pull/3597#issuecomment-1872114647 ## [![Quality Gate Passed](https://sonarsource.github.io/sonarcloud-github-static-resources/v2/checks/QualityGateBadge/qg-passed-20px.png 'Quality Gate

Re: [PR] [CALCITE-6162] Add rule(s) to remove joins with constant single tuple… [calcite]

2023-12-27 Thread via GitHub
mihaibudiu commented on code in PR #3597: URL: https://github.com/apache/calcite/pull/3597#discussion_r1437174199 ## core/src/test/java/org/apache/calcite/test/RelOptRulesTest.java: ## @@ -4177,6 +4178,109 @@ RelOptFixture checkDynamicFunctions(boolean

Re: [PR] [CALCITE-6162] Add rule(s) to remove joins with constant single tuple… [calcite]

2023-12-27 Thread via GitHub
HanumathRao commented on code in PR #3597: URL: https://github.com/apache/calcite/pull/3597#discussion_r1437080384 ## core/src/test/java/org/apache/calcite/test/RelOptRulesTest.java: ## @@ -4177,6 +4178,109 @@ RelOptFixture checkDynamicFunctions(boolean

Re: [PR] [CALCITE-6162] Add rule(s) to remove joins with constant single tuple… [calcite]

2023-12-26 Thread via GitHub
mihaibudiu commented on code in PR #3597: URL: https://github.com/apache/calcite/pull/3597#discussion_r1436564290 ## core/src/test/java/org/apache/calcite/test/RelOptRulesTest.java: ## @@ -4177,6 +4178,109 @@ RelOptFixture checkDynamicFunctions(boolean

[PR] [CALCITE-6162] Add rule(s) to remove joins with constant single tuple… [calcite]

2023-12-25 Thread via GitHub
HanumathRao opened a new pull request, #3597: URL: https://github.com/apache/calcite/pull/3597 … relations This PR introduces four rules for simplifying joins with a single value row on either side of the input. Please find the information about this optimizations in the related