[jira] [Commented] (CALCITE-3679) Allow lambda expressions in SQL queries

2020-05-04 Thread Ritesh (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-3679?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17099514#comment-17099514 ] Ritesh commented on CALCITE-3679: - cc: [~zabetak] > Allow lambda expressions in SQL queries >

[jira] [Commented] (CALCITE-3679) Allow lambda expressions in SQL queries

2020-05-04 Thread Ritesh (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-3679?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17099512#comment-17099512 ] Ritesh commented on CALCITE-3679: - It would be really great if this feature could make it to 1.23.0

[jira] [Updated] (CALCITE-3866) ReturnTypes.AGG_SUM may cause "numeric field overflow" on PostgreSQL when generate the sql after using the rule AggregateJoinTransposeRule.EXTENDED.

2020-05-04 Thread Haisheng Yuan (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-3866?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Haisheng Yuan updated CALCITE-3866: --- Fix Version/s: 1.23.0 > ReturnTypes.AGG_SUM may cause "numeric field overflow" on

[jira] [Updated] (CALCITE-3926) CannotPlanException when an empty LogicalValues requires a certain collation

2020-05-04 Thread Haisheng Yuan (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-3926?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Haisheng Yuan updated CALCITE-3926: --- Fix Version/s: 1.23.0 > CannotPlanException when an empty LogicalValues requires a certain

[jira] [Updated] (CALCITE-3961) VolcanoPlanner.prunedNodes information is lost when duplicate relNode is discarded

2020-05-04 Thread Haisheng Yuan (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-3961?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Haisheng Yuan updated CALCITE-3961: --- Fix Version/s: 1.23.0 > VolcanoPlanner.prunedNodes information is lost when duplicate

[jira] [Commented] (CALCITE-2970) Performance issue when enabling abstract converter for EnumerableConvention

2020-05-04 Thread Xiening Dai (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-2970?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17099490#comment-17099490 ] Xiening Dai commented on CALCITE-2970: -- Will create a new JIRA. {quote} Struct's constructor

[jira] [Commented] (CALCITE-2970) Performance issue when enabling abstract converter for EnumerableConvention

2020-05-04 Thread Julian Hyde (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-2970?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17099483#comment-17099483 ] Julian Hyde commented on CALCITE-2970: -- Can we have a new JIRA case focused just on PR 1884? The

[jira] [Commented] (CALCITE-3970) Table-valued function TUMBLE uses non-standard syntax

2020-05-04 Thread Julian Hyde (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-3970?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17099468#comment-17099468 ] Julian Hyde commented on CALCITE-3970: -- No, the two existing syntax are {code:sql} select * from

[jira] [Commented] (CALCITE-3969) Method RelTrait.apply(Mappings.Mapping) throws exception when mapping doesn't cover collation or distribution keys

2020-05-04 Thread Julian Hyde (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-3969?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17099459#comment-17099459 ] Julian Hyde commented on CALCITE-3969: -- I'm not sure I agree. Consider an example: * Suppose we

[jira] [Updated] (CALCITE-3969) Method RelTrait.apply(Mappings.Mapping) throws exception when mapping doesn't cover collation or distribution keys

2020-05-04 Thread Haisheng Yuan (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-3969?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Haisheng Yuan updated CALCITE-3969: --- Fix Version/s: 1.23.0 > Method RelTrait.apply(Mappings.Mapping) throws exception when

[jira] [Commented] (CALCITE-3970) Table-valued function TUMBLE uses non-standard syntax

2020-05-04 Thread Rui Wang (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-3970?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17099427#comment-17099427 ] Rui Wang commented on CALCITE-3970: --- So to conclude, there are two syntax of "TABLE" {code:sql}

[jira] [Commented] (CALCITE-3970) Table-valued function TUMBLE uses non-standard syntax

2020-05-04 Thread Julian Hyde (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-3970?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17099425#comment-17099425 ] Julian Hyde commented on CALCITE-3970: -- [~vilo] I believe there are two different uses of

[jira] [Comment Edited] (CALCITE-3955) Remove the first operand of RexCall from SqlWindowTableFunction

2020-05-04 Thread Rui Wang (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-3955?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17099406#comment-17099406 ] Rui Wang edited comment on CALCITE-3955 at 5/4/20, 11:11 PM: - Thanks

[jira] [Commented] (CALCITE-3955) Remove the first operand of RexCall from SqlWindowTableFunction

2020-05-04 Thread Rui Wang (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-3955?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17099406#comment-17099406 ] Rui Wang commented on CALCITE-3955: --- Thanks Julian. I digged into what you suggested and wanted to

[jira] [Comment Edited] (CALCITE-3955) Remove the first operand of RexCall from SqlWindowTableFunction

2020-05-04 Thread Rui Wang (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-3955?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17099406#comment-17099406 ] Rui Wang edited comment on CALCITE-3955 at 5/4/20, 10:59 PM: - Thanks

[jira] [Commented] (CALCITE-2970) Performance issue when enabling abstract converter for EnumerableConvention

2020-05-04 Thread Xiening Dai (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-2970?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17099402#comment-17099402 ] Xiening Dai commented on CALCITE-2970: -- I don't think we would ever put it into Calcite - it's a

[jira] [Commented] (CALCITE-3970) Table-valued function TUMBLE uses non-standard syntax

2020-05-04 Thread Rui Wang (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-3970?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17099401#comment-17099401 ] Rui Wang commented on CALCITE-3970: --- I did encounter the same confusion before: "TABLE(t)" does not

[jira] [Commented] (CALCITE-2970) Performance issue when enabling abstract converter for EnumerableConvention

2020-05-04 Thread Stamatis Zampetakis (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-2970?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17099398#comment-17099398 ] Stamatis Zampetakis commented on CALCITE-2970: -- Thanks for bearing with me [~xndai]  :) I

[jira] [Commented] (CALCITE-2970) Performance issue when enabling abstract converter for EnumerableConvention

2020-05-04 Thread Xiening Dai (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-2970?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17099395#comment-17099395 ] Xiening Dai commented on CALCITE-2970: -- {quote}Out of curiosity can you explain at which point you

[jira] [Assigned] (CALCITE-3920) Improve ORDER BY computation in Enumerable convention by exploiting LIMIT

2020-05-04 Thread Stamatis Zampetakis (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-3920?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Stamatis Zampetakis reassigned CALCITE-3920: Assignee: (was: Stamatis Zampetakis) > Improve ORDER BY computation

[jira] [Updated] (CALCITE-3920) Improve ORDER BY computation in Enumerable convention by exploiting LIMIT

2020-05-04 Thread Stamatis Zampetakis (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-3920?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Stamatis Zampetakis updated CALCITE-3920: - Fix Version/s: (was: 1.23.0) > Improve ORDER BY computation in Enumerable

[jira] [Commented] (CALCITE-2970) Performance issue when enabling abstract converter for EnumerableConvention

2020-05-04 Thread Stamatis Zampetakis (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-2970?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17099388#comment-17099388 ] Stamatis Zampetakis commented on CALCITE-2970: -- Out of curiosity can you explain at which

[jira] [Commented] (CALCITE-2970) Performance issue when enabling abstract converter for EnumerableConvention

2020-05-04 Thread Xiening Dai (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-2970?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17099212#comment-17099212 ] Xiening Dai commented on CALCITE-2970: -- {quote} The example outlined by Xiening Dai previously

[jira] [Commented] (CALCITE-2970) Performance issue when enabling abstract converter for EnumerableConvention

2020-05-04 Thread Stamatis Zampetakis (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-2970?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17099182#comment-17099182 ] Stamatis Zampetakis commented on CALCITE-2970: -- Before talking about code that is not

[jira] [Resolved] (CALCITE-3958) Revise documentation of gradle.properties in Cassandra/Piglet and SubstitutionVisitor

2020-05-04 Thread Haisheng Yuan (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-3958?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Haisheng Yuan resolved CALCITE-3958. Fix Version/s: 1.23.0 Resolution: Fixed Fixed in 

[jira] [Created] (CALCITE-3971) Support Calc in RelMdColumnOrigins

2020-05-04 Thread xzh_dz (Jira)
xzh_dz created CALCITE-3971: --- Summary: Support Calc in RelMdColumnOrigins Key: CALCITE-3971 URL: https://issues.apache.org/jira/browse/CALCITE-3971 Project: Calcite Issue Type: Wish

[jira] [Resolved] (CALCITE-3921) Support TableModify json serialization and deserialization

2020-05-04 Thread Haisheng Yuan (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-3921?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Haisheng Yuan resolved CALCITE-3921. Fix Version/s: 1.23.0 Resolution: Fixed Fixed in 

[jira] [Updated] (CALCITE-3921) Support TableModify json serialization and deserialization

2020-05-04 Thread Haisheng Yuan (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-3921?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Haisheng Yuan updated CALCITE-3921: --- Summary: Support TableModify json serialization and deserialization (was: Support

[jira] [Updated] (CALCITE-3970) Table-valued function TUMBLE uses non-standard syntax

2020-05-04 Thread Viliam Durina (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-3970?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Viliam Durina updated CALCITE-3970: --- Description: The currently supported syntax is this: {code:java} SELECT * FROM

[jira] [Created] (CALCITE-3970) Table-valued function TUMBLE uses non-standard syntax

2020-05-04 Thread Viliam Durina (Jira)
Viliam Durina created CALCITE-3970: -- Summary: Table-valued function TUMBLE uses non-standard syntax Key: CALCITE-3970 URL: https://issues.apache.org/jira/browse/CALCITE-3970 Project: Calcite

[jira] [Commented] (CALCITE-3339) DESCRIPTOR as a SQL operator in SqlStdOperatorTable

2020-05-04 Thread Viliam Durina (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-3339?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17098758#comment-17098758 ] Viliam Durina commented on CALCITE-3339: The standard is public here: