[jira] [Updated] (CALCITE-3196) In Frameworks, add BasePrepareAction (a functional interface) and deprecate PrepareAction

[ https://issues.apache.org/jira/browse/CALCITE-3196?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] ASF GitHub Bot updated CALCITE-3196: Labels: pull-request-available (was: ) > In Frameworks, add BasePrepareAction (a functio

[jira] [Reopened] (CALCITE-2978) sorting not applied in subqueries

[ https://issues.apache.org/jira/browse/CALCITE-2978?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Pressenna reopened CALCITE-2978: > sorting not applied in subqueries > - > > Key: CALC

[jira] [Commented] (CALCITE-2978) sorting not applied in subqueries

[ https://issues.apache.org/jira/browse/CALCITE-2978?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16884979#comment-16884979 ] Pressenna commented on CALCITE-2978: So I think I finally found a valid use case fo

[jira] [Commented] (CALCITE-2978) sorting not applied in subqueries

[ https://issues.apache.org/jira/browse/CALCITE-2978?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16884987#comment-16884987 ] Haisheng Yuan commented on CALCITE-2978: This is still not a valid case, unless

[jira] [Resolved] (CALCITE-2978) sorting not applied in subqueries

[ https://issues.apache.org/jira/browse/CALCITE-2978?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Pressenna resolved CALCITE-2978. Resolution: Invalid It works correctly when a LIMIT is applied (then the sorting is done correctl

[jira] [Created] (CALCITE-3198) ReduceExpressionsRule.FILTER_INSTANCE does not reduce 'NOT(x=a AND x=b)'

Ruben Quesada Lopez created CALCITE-3198: Summary: ReduceExpressionsRule.FILTER_INSTANCE does not reduce 'NOT(x=a AND x=b)' Key: CALCITE-3198 URL: https://issues.apache.org/jira/browse/CALCITE-3198

[jira] [Commented] (CALCITE-2978) sorting not applied in subqueries

[ https://issues.apache.org/jira/browse/CALCITE-2978?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16884999#comment-16884999 ] Pressenna commented on CALCITE-2978: [~hyuan], yes, you are right, sorry for reopen

[jira] [Updated] (CALCITE-3198) ReduceExpressionsRule.FILTER_INSTANCE does not reduce 'NOT(x=a AND x=b)'

[ https://issues.apache.org/jira/browse/CALCITE-3198?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Ruben Quesada Lopez updated CALCITE-3198: - Description: Currently, ReduceExpressionsRule.FILTER_INSTANCE can successfully

[jira] [Commented] (CALCITE-3198) ReduceExpressionsRule.FILTER_INSTANCE does not reduce 'NOT(x=a AND x=b)'

[ https://issues.apache.org/jira/browse/CALCITE-3198?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16885045#comment-16885045 ] Ruben Quesada Lopez commented on CALCITE-3198: -- Same result is obtained wi

[jira] [Comment Edited] (CALCITE-3198) ReduceExpressionsRule.FILTER_INSTANCE does not reduce 'NOT(x=a AND x=b)'

[ https://issues.apache.org/jira/browse/CALCITE-3198?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16885045#comment-16885045 ] Ruben Quesada Lopez edited comment on CALCITE-3198 at 7/15/19 10:24 AM: -

[jira] [Resolved] (CALCITE-3183) Trimming method for Filter rel uses wrong traitSet

[ https://issues.apache.org/jira/browse/CALCITE-3183?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Julian Hyde resolved CALCITE-3183. -- Resolution: Fixed Fix Version/s: 1.21.0 Fixed in [bb0bae9|https://github.com/julianhyd

[jira] [Resolved] (CALCITE-3196) In Frameworks, add BasePrepareAction (a functional interface) and deprecate PrepareAction

[ https://issues.apache.org/jira/browse/CALCITE-3196?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Julian Hyde resolved CALCITE-3196. -- Resolution: Fixed Fix Version/s: 1.21.0 Fixed in [1c5de1c|https://github.com/julianhyd

[jira] [Resolved] (CALCITE-3144) Add rule, CaseFilteredAggregatorRule, that converts "SUM(CASE WHEN b THEN x END)" to "SUM(x) FILTER (WHERE b)"

[ https://issues.apache.org/jira/browse/CALCITE-3144?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Julian Hyde resolved CALCITE-3144. -- Resolution: Fixed Fixed in [687b7d8|https://github.com/julianhyde/calcite/commit/687b7d8]. T

[jira] [Updated] (CALCITE-3144) Add rule, AggregateCaseToFilterRule, that converts "SUM(CASE WHEN b THEN x END)" to "SUM(x) FILTER (WHERE b)"

[ https://issues.apache.org/jira/browse/CALCITE-3144?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Julian Hyde updated CALCITE-3144: - Summary: Add rule, AggregateCaseToFilterRule, that converts "SUM(CASE WHEN b THEN x END)" to "S

[jira] [Commented] (CALCITE-3144) Add rule, AggregateCaseToFilterRule, that converts "SUM(CASE WHEN b THEN x END)" to "SUM(x) FILTER (WHERE b)"

[ https://issues.apache.org/jira/browse/CALCITE-3144?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16885460#comment-16885460 ] Julian Hyde commented on CALCITE-3144: -- For a follow-up task, it would be good if

[jira] [Resolved] (CALCITE-3166) Make RelBuilder configurable

[ https://issues.apache.org/jira/browse/CALCITE-3166?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Julian Hyde resolved CALCITE-3166. -- Resolution: Fixed Fixed in [15e6378 |https://github.com/julianhyde/calcite/commit/15e6378].

[jira] [Resolved] (CALCITE-3145) RelBuilder.aggregate throws IndexOutOfBoundsException if groupKey is non-empty and there are duplicate aggregate functions

[ https://issues.apache.org/jira/browse/CALCITE-3145?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Julian Hyde resolved CALCITE-3145. -- Resolution: Fixed Fix Version/s: 1.21.0 Fixed in [0cce229|https://github.com/julianhyd

[jira] [Commented] (CALCITE-3122) Convert Pig Latin scripts into Calcite logical plan

[ https://issues.apache.org/jira/browse/CALCITE-3122?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16885464#comment-16885464 ] Khai Tran commented on CALCITE-3122: Hi [~zabetak], thanks a lot for your suggestio

[jira] [Commented] (CALCITE-3122) Convert Pig Latin scripts into Calcite logical plan

[ https://issues.apache.org/jira/browse/CALCITE-3122?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16885472#comment-16885472 ] Khai Tran commented on CALCITE-3122: CALCITE-1681 is really what I need if we canno

[jira] [Commented] (CALCITE-3198) ReduceExpressionsRule.FILTER_INSTANCE does not reduce 'NOT(x=a AND x=b)'

[ https://issues.apache.org/jira/browse/CALCITE-3198?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16885475#comment-16885475 ] Julian Hyde commented on CALCITE-3198: -- {{ReduceExpressionsRule}} is about constan

[jira] [Commented] (CALCITE-3187) Derive all decimal return type through type factory

[ https://issues.apache.org/jira/browse/CALCITE-3187?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16885486#comment-16885486 ] Julian Hyde commented on CALCITE-3187: -- [~laurent] There are still copy editing is

[jira] [Commented] (CALCITE-3197) Convert data of Timestamp/Time/Date as original form when enumerating from ArrayTable

[ https://issues.apache.org/jira/browse/CALCITE-3197?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16885520#comment-16885520 ] Julian Hyde commented on CALCITE-3197: -- This PR makes the code a lot less elegant.

[jira] [Commented] (CALCITE-3122) Convert Pig Latin scripts into Calcite logical plan

[ https://issues.apache.org/jira/browse/CALCITE-3122?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16885532#comment-16885532 ] Julian Hyde commented on CALCITE-3122: -- Or perhaps even CALCITE-1536, the holy gra

[jira] [Commented] (CALCITE-3181) Support limit per group in Window

[ https://issues.apache.org/jira/browse/CALCITE-3181?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16885545#comment-16885545 ] Julian Hyde commented on CALCITE-3181: -- The {{enum RelFieldCollation}} has values

[jira] [Commented] (CALCITE-3113) Equivalent MutableAggregates with different row types fail with AssertionError

[ https://issues.apache.org/jira/browse/CALCITE-3113?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16885546#comment-16885546 ] Julian Hyde commented on CALCITE-3113: -- It seems necessary that the before and aft

[jira] [Commented] (CALCITE-3187) Derive all decimal return type through type factory

[ https://issues.apache.org/jira/browse/CALCITE-3187?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16885548#comment-16885548 ] Laurent Goujon commented on CALCITE-3187: - Will do. > Derive all decimal retur

[jira] [Commented] (CALCITE-3178) RexSimplify.simplifyOrTerms slow with large OR filters

[ https://issues.apache.org/jira/browse/CALCITE-3178?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16885556#comment-16885556 ] Julian Hyde commented on CALCITE-3178: -- The ideal fix, in my view, would be to mak

[jira] [Commented] (CALCITE-3122) Convert Pig Latin scripts into Calcite logical plan

[ https://issues.apache.org/jira/browse/CALCITE-3122?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16885562#comment-16885562 ] Khai Tran commented on CALCITE-3122: I dont need. But the planner will complaint th

[jira] [Updated] (CALCITE-3186) IN expressions in UPDATE statements throws Exceptions

[ https://issues.apache.org/jira/browse/CALCITE-3186?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Danny Chan updated CALCITE-3186: Summary: IN expressions in UPDATE statements throws Exceptions (was: IN expressions in UPDATE st

[jira] [Commented] (CALCITE-3197) Convert data of Timestamp/Time/Date as original form when enumerating from ArrayTable

[ https://issues.apache.org/jira/browse/CALCITE-3197?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16885816#comment-16885816 ] jin xing commented on CALCITE-3197: --- [~julianhyde] THX a lot for comment. “The idea

[jira] [Commented] (CALCITE-3195) Fix enumerable code generator to handle UDFs that throws checked Exceptions

[ https://issues.apache.org/jira/browse/CALCITE-3195?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16885875#comment-16885875 ] Feng Zhu commented on CALCITE-3195: --- Hi, [~khaitran]. I opend a PR (https://github.co