[jira] [Commented] (CALCITE-3160) Failed to materialize when the aggregate function uses group key

[ https://issues.apache.org/jira/browse/CALCITE-3160?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16876680#comment-16876680 ] Feng Zhu commented on CALCITE-3160: --- I have also noticed such kind of issues. (1)When sum(empid),

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

[ https://issues.apache.org/jira/browse/CALCITE-3166?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16876677#comment-16876677 ] Danny Chan commented on CALCITE-3166: - Thanks [~julianhyde], i'm ok with this Context unwrap, cause

[jira] [Comment Edited] (CALCITE-3166) Make RelBuilder configurable

[ https://issues.apache.org/jira/browse/CALCITE-3166?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16876634#comment-16876634 ] Julian Hyde edited comment on CALCITE-3166 at 7/2/19 3:25 AM: -- {quote}Does

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

[ https://issues.apache.org/jira/browse/CALCITE-3166?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16876634#comment-16876634 ] Julian Hyde commented on CALCITE-3166: -- {quote}Does this mean we should always make a

[jira] [Commented] (CALCITE-3152) Unify throws in sql parser

[ https://issues.apache.org/jira/browse/CALCITE-3152?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16876604#comment-16876604 ] Danny Chan commented on CALCITE-3152: - I'm gonna merge this PR if there are no more comments in 24

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

[ https://issues.apache.org/jira/browse/CALCITE-3166?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16876603#comment-16876603 ] Danny Chan commented on CALCITE-3166: - Reviewed and left some comments. > Make RelBuilder

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

[ https://issues.apache.org/jira/browse/CALCITE-3166?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Julian Hyde updated CALCITE-3166: - Fix Version/s: 1.21.0 > Make RelBuilder configurable > > >

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

[ https://issues.apache.org/jira/browse/CALCITE-3166?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16876579#comment-16876579 ] Julian Hyde commented on CALCITE-3166: -- Can someone please review

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

[ https://issues.apache.org/jira/browse/CALCITE-3166?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Julian Hyde updated CALCITE-3166: - Labels: pull-request-available (was: ) > Make RelBuilder configurable >

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

[ https://issues.apache.org/jira/browse/CALCITE-3166?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Julian Hyde reassigned CALCITE-3166: Assignee: Julian Hyde > Make RelBuilder configurable > > >

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

Julian Hyde created CALCITE-3166: Summary: Make RelBuilder configurable Key: CALCITE-3166 URL: https://issues.apache.org/jira/browse/CALCITE-3166 Project: Calcite Issue Type: Bug

[jira] [Updated] (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 updated CALCITE-3144: - Fix Version/s: 1.21.0 > Add rule, CaseFilteredAggregatorRule, that converts "SUM(CASE WHEN b

[jira] [Commented] (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:comment-tabpanel=16876551#comment-16876551 ] Julian Hyde commented on CALCITE-3144: -- Can someone please review 

[jira] [Commented] (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:comment-tabpanel=16876495#comment-16876495 ] Gian Merlino commented on CALCITE-3144: --- > Gian Merlino, Do you recall the reason for this line?

[jira] [Assigned] (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 reassigned CALCITE-3144: Assignee: Julian Hyde > Add rule, CaseFilteredAggregatorRule, that converts "SUM(CASE

[jira] [Commented] (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:comment-tabpanel=16876418#comment-16876418 ] Julian Hyde commented on CALCITE-3144: -- [~gian], Do you recall the reason for this line? I don't

[jira] [Comment Edited] (CALCITE-3159) Distinct can be removed for MIN/MAX/BIT_OR/BIT_AND aggregate functions

[ https://issues.apache.org/jira/browse/CALCITE-3159?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16876409#comment-16876409 ] Julian Hyde edited comment on CALCITE-3159 at 7/1/19 6:26 PM: -- I agree.

[jira] [Commented] (CALCITE-3159) Distinct can be removed for MIN/MAX/BIT_OR/BIT_AND aggregate functions

[ https://issues.apache.org/jira/browse/CALCITE-3159?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16876409#comment-16876409 ] Julian Hyde commented on CALCITE-3159: -- I agree. Maybe add a method {{Optionality

[jira] [Commented] (CALCITE-1935) Reference implementation for MATCH_RECOGNIZE

[ https://issues.apache.org/jira/browse/CALCITE-1935?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16876391#comment-16876391 ] Julian Hyde commented on CALCITE-1935: -- It's not very important that you squash; it's more

[jira] [Commented] (CALCITE-3165) Project#accept(RexShuttle shuttle) does not update rowType

[ https://issues.apache.org/jira/browse/CALCITE-3165?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16876380#comment-16876380 ] Haisheng Yuan commented on CALCITE-3165: Yup, a test case might be helpful. >

[jira] [Comment Edited] (CALCITE-3165) Project#accept(RexShuttle shuttle) does not update rowType

[ https://issues.apache.org/jira/browse/CALCITE-3165?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16876315#comment-16876315 ] Ruben Quesada Lopez edited comment on CALCITE-3165 at 7/1/19 4:15 PM:

[jira] [Commented] (CALCITE-3165) Project#accept(RexShuttle shuttle) does not update rowType

[ https://issues.apache.org/jira/browse/CALCITE-3165?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16876315#comment-16876315 ] Ruben Quesada Lopez commented on CALCITE-3165: -- Currently, Project#accept(RexShuttle

[jira] [Created] (CALCITE-3165) Project#accept(RexShuttle shuttle) does not update rowType

Ruben Quesada Lopez created CALCITE-3165: Summary: Project#accept(RexShuttle shuttle) does not update rowType Key: CALCITE-3165 URL: https://issues.apache.org/jira/browse/CALCITE-3165 Project:

[jira] [Resolved] (CALCITE-3125) Remove completely CorrelateJoinType

[ https://issues.apache.org/jira/browse/CALCITE-3125?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Ruben Quesada Lopez resolved CALCITE-3125. -- Resolution: Fixed Fixed in

[jira] [Created] (CALCITE-3164) Averaging an all-nulls values after grouping produce NaN instead of NULL

Muhammad Gelbana created CALCITE-3164: - Summary: Averaging an all-nulls values after grouping produce NaN instead of NULL Key: CALCITE-3164 URL: https://issues.apache.org/jira/browse/CALCITE-3164

[jira] [Updated] (CALCITE-3125) Remove completely CorrelateJoinType

[ https://issues.apache.org/jira/browse/CALCITE-3125?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] ASF GitHub Bot updated CALCITE-3125: Labels: pull-request-available (was: ) > Remove completely CorrelateJoinType >

[jira] [Resolved] (CALCITE-3133) Remove completely SemiJoinType

[ https://issues.apache.org/jira/browse/CALCITE-3133?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Ruben Quesada Lopez resolved CALCITE-3133. -- Resolution: Fixed Fixed in

[jira] [Updated] (CALCITE-3163) Mapping of Types in AbstractCursor#convertValue() does not adhere to JDBC specifications

[ https://issues.apache.org/jira/browse/CALCITE-3163?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Ralph Gasser updated CALCITE-3163: -- Description: This is an issue I found while working on CALCITE-3162: According to my

[jira] [Updated] (CALCITE-3163) Mapping of Types in AbstractCursor#convertValue() does not adhere to JDBC specifications

[ https://issues.apache.org/jira/browse/CALCITE-3163?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Ralph Gasser updated CALCITE-3163: -- Description: This is an issue I found while working on CALCITE-3162: According to my

[jira] [Updated] (CALCITE-3163) Mapping of Types in AbstractCursor#convertValue() does not adhere to JDBC specifications

[ https://issues.apache.org/jira/browse/CALCITE-3163?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Ralph Gasser updated CALCITE-3163: -- Summary: Mapping of Types in AbstractCursor#convertValue() does not adhere to JDBC

[jira] [Updated] (CALCITE-3162) Reading Arrays from Calcite through JdbcMeta generates AvaticaSqlException

[ https://issues.apache.org/jira/browse/CALCITE-3162?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Ralph Gasser updated CALCITE-3162: -- Summary: Reading Arrays from Calcite through JdbcMeta generates AvaticaSqlException (was:

[jira] [Created] (CALCITE-3163) Mapping of Types in AbstractCursor#convertValue() does not adhere to JDBC specification

Ralph Gasser created CALCITE-3163: - Summary: Mapping of Types in AbstractCursor#convertValue() does not adhere to JDBC specification Key: CALCITE-3163 URL: https://issues.apache.org/jira/browse/CALCITE-3163

[jira] [Updated] (CALCITE-3162) Reading Arrays from Calcite using Avatica generates error

[ https://issues.apache.org/jira/browse/CALCITE-3162?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Ralph Gasser updated CALCITE-3162: -- Description: I'm trying to use _Apache Calcite_ as SQL Parser and Query Planner for a custom

[jira] [Closed] (CALCITE-3161) Remove deprecated SemiJoinType usage completely

[ https://issues.apache.org/jira/browse/CALCITE-3161?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Ruben Quesada Lopez closed CALCITE-3161. Resolution: Duplicate Closing as duplicated of CALCITE-3133 > Remove deprecated

[jira] [Updated] (CALCITE-3133) Remove completely SemiJoinType

[ https://issues.apache.org/jira/browse/CALCITE-3133?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] ASF GitHub Bot updated CALCITE-3133: Labels: pull-request-available (was: ) > Remove completely SemiJoinType >

[jira] [Commented] (CALCITE-3161) Remove deprecated SemiJoinType usage completely

[ https://issues.apache.org/jira/browse/CALCITE-3161?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16876067#comment-16876067 ] Ruben Quesada Lopez commented on CALCITE-3161: -- Ok, [~danny0405], I'll start working on

[jira] [Updated] (CALCITE-3162) Reading Arrays from Calcite using Avatica generates error

[ https://issues.apache.org/jira/browse/CALCITE-3162?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Ralph Gasser updated CALCITE-3162: -- Description: I'm trying to use _Apache Calcite_ as SQL Parser and Query Planner for a custom

[jira] [Commented] (CALCITE-3161) Remove deprecated SemiJoinType usage completely

[ https://issues.apache.org/jira/browse/CALCITE-3161?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16876064#comment-16876064 ] Danny Chan commented on CALCITE-3161: - [~rubenql] Oops, i'm so sorry that i missed your JIRA issue,

[jira] [Created] (CALCITE-3162) Reading Arrays from Calcite using Avatica generates error

Ralph Gasser created CALCITE-3162: - Summary: Reading Arrays from Calcite using Avatica generates error Key: CALCITE-3162 URL: https://issues.apache.org/jira/browse/CALCITE-3162 Project: Calcite

[jira] [Comment Edited] (CALCITE-3161) Remove deprecated SemiJoinType usage completely

[ https://issues.apache.org/jira/browse/CALCITE-3161?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16876042#comment-16876042 ] Ruben Quesada Lopez edited comment on CALCITE-3161 at 7/1/19 9:28 AM:

[jira] [Comment Edited] (CALCITE-3161) Remove deprecated SemiJoinType usage completely

[ https://issues.apache.org/jira/browse/CALCITE-3161?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16876042#comment-16876042 ] Ruben Quesada Lopez edited comment on CALCITE-3161 at 7/1/19 9:28 AM:

[jira] [Commented] (CALCITE-3161) Remove deprecated SemiJoinType usage completely

[ https://issues.apache.org/jira/browse/CALCITE-3161?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16876042#comment-16876042 ] Ruben Quesada Lopez commented on CALCITE-3161: -- [~danny0405], sorry, I had already created

[jira] [Created] (CALCITE-3161) Remove deprecated SemiJoinType usage completely

Danny Chan created CALCITE-3161: --- Summary: Remove deprecated SemiJoinType usage completely Key: CALCITE-3161 URL: https://issues.apache.org/jira/browse/CALCITE-3161 Project: Calcite Issue

[jira] [Resolved] (CALCITE-3126) Remove deprecated SemiJoin usage completely

[ https://issues.apache.org/jira/browse/CALCITE-3126?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Danny Chan resolved CALCITE-3126. - Resolution: Fixed Fixed in