[jira] [Updated] (CALCITE-3521) CalciteSystemProperty can't load config file

2019-11-25 Thread ASF GitHub Bot (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-3521?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] ASF GitHub Bot updated CALCITE-3521: Labels: pull-request-available (was: ) > CalciteSystemProperty can't load config file >

[jira] [Updated] (CALCITE-3466) JDBC adapter dropped group by statement in subquery

2019-11-25 Thread ASF GitHub Bot (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-3466?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] ASF GitHub Bot updated CALCITE-3466: Labels: pull-request-available (was: ) > JDBC adapter dropped group by statement in

[jira] [Commented] (CALCITE-3521) CalciteSystemProperty can't load config file

2019-11-25 Thread Jin Xing (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-3521?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16982191#comment-16982191 ] Jin Xing commented on CALCITE-3521: --- PR by [~hyuan] [https://github.com/apache/calcite/pull/1604] >

[jira] [Updated] (CALCITE-3536) Wrong semantics in CoalesceImplementor

2019-11-25 Thread Jin Xing (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-3536?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Jin Xing updated CALCITE-3536: -- Description: Currently, COALESCE expression specified in sql string will be rewrite to CASE by

[jira] [Commented] (CALCITE-3536) Wrong semantics in CoalesceImplementor

2019-11-25 Thread Jin Xing (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-3536?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16982104#comment-16982104 ] Jin Xing commented on CALCITE-3536: --- Yes, I added in the description and proposed a PR to illustrate

[jira] [Updated] (CALCITE-3536) Wrong semantics in CoalesceImplementor

2019-11-25 Thread ASF GitHub Bot (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-3536?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] ASF GitHub Bot updated CALCITE-3536: Labels: pull-request-available (was: ) > Wrong semantics in CoalesceImplementor >

[jira] [Commented] (CALCITE-3531) AggregateProjectPullUpConstantsRule should not remove deterministic function group key if the function is dynamic

2019-11-25 Thread Danny Chen (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-3531?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16982099#comment-16982099 ] Danny Chen commented on CALCITE-3531: - I found this one in SQL standard 2011: bq. Let S be an that

[jira] [Comment Edited] (CALCITE-3531) AggregateProjectPullUpConstantsRule should not remove deterministic function group key if the function is dynamic

2019-11-25 Thread Danny Chen (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-3531?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16982099#comment-16982099 ] Danny Chen edited comment on CALCITE-3531 at 11/26/19 3:16 AM: --- I found

[jira] [Reopened] (CALCITE-3531) AggregateProjectPullUpConstantsRule should not remove deterministic function group key if the function is dynamic

2019-11-25 Thread Danny Chen (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-3531?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Danny Chen reopened CALCITE-3531: - > AggregateProjectPullUpConstantsRule should not remove deterministic function > group key if the

[jira] [Updated] (CALCITE-3536) Wrong semantics in CoalesceImplementor

2019-11-25 Thread Jin Xing (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-3536?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Jin Xing updated CALCITE-3536: -- Description: Currently, COALESCE expression specified in sql string will be rewrite to CASE by

[jira] [Updated] (CALCITE-3536) Wrong semantics in CoalesceImplementor

2019-11-25 Thread Jin Xing (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-3536?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Jin Xing updated CALCITE-3536: -- Description: Currently, COALESCE expression specified in sql string will be rewrite to CASE by

[jira] [Commented] (CALCITE-3531) AggregateProjectPullUpConstantsRule should not remove deterministic function group key if the function is dynamic

2019-11-25 Thread Danny Chen (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-3531?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16982094#comment-16982094 ] Danny Chen commented on CALCITE-3531: - Thanks, Julian, i didn't find any evidence that

[jira] [Commented] (CALCITE-3536) Wrong semantics in CoalesceImplementor

2019-11-25 Thread Julian Hyde (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-3536?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16982088#comment-16982088 ] Julian Hyde commented on CALCITE-3536: -- What are the wrong semantics? Test case? > Wrong

[jira] [Created] (CALCITE-3536) Wrong semantics in CoalesceImplementor

2019-11-25 Thread Jin Xing (Jira)
Jin Xing created CALCITE-3536: - Summary: Wrong semantics in CoalesceImplementor Key: CALCITE-3536 URL: https://issues.apache.org/jira/browse/CALCITE-3536 Project: Calcite Issue Type: Bug

[jira] [Commented] (CALCITE-3534) Support parse(unparse) alien system non-standard data type

2019-11-25 Thread Julian Hyde (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-3534?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16982079#comment-16982079 ] Julian Hyde commented on CALCITE-3534: -- Please revert. You didn't give enough time to review. >

[jira] [Commented] (CALCITE-3473) Getting unique result for table scan should contain key column(s)

2019-11-25 Thread Julian Hyde (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-3473?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16982076#comment-16982076 ] Julian Hyde commented on CALCITE-3473: -- I see that the new commit adds {{RelOptTable.getKeys()}}.

[jira] [Commented] (CALCITE-3496) Hive dialect support with cube and with rollup

2019-11-25 Thread Julian Hyde (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-3496?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16982066#comment-16982066 ] Julian Hyde commented on CALCITE-3496: -- Hive dialect support where? In the JDBC adapter or in the

[jira] [Comment Edited] (CALCITE-3531) AggregateProjectPullUpConstantsRule should not remove deterministic function group key if the function is dynamic

2019-11-25 Thread Julian Hyde (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-3531?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16982045#comment-16982045 ] Julian Hyde edited comment on CALCITE-3531 at 11/26/19 1:45 AM: I think

[jira] [Commented] (CALCITE-3531) AggregateProjectPullUpConstantsRule should not remove deterministic function group key if the function is dynamic

2019-11-25 Thread Julian Hyde (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-3531?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16982045#comment-16982045 ] Julian Hyde commented on CALCITE-3531: -- I think we got this wrong. First of all,

[jira] [Closed] (CALCITE-3343) Improve LogicalTableFunctionScan to match table function windowing

2019-11-25 Thread Rui Wang (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-3343?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Rui Wang closed CALCITE-3343. - Resolution: Not A Problem > Improve LogicalTableFunctionScan to match table function windowing >

[jira] [Commented] (CALCITE-3343) Improve LogicalTableFunctionScan to match table function windowing

2019-11-25 Thread Rui Wang (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-3343?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16981993#comment-16981993 ] Rui Wang commented on CALCITE-3343: --- It turns out reusing existing rexCall is good enough. Closing

[jira] [Commented] (CALCITE-3531) AggregateProjectPullUpConstantsRule should not remove deterministic function group key if the function is dynamic

2019-11-25 Thread Rui Wang (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-3531?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16981814#comment-16981814 ] Rui Wang commented on CALCITE-3531: --- Thanks Danny for your explanation! Also thanks for links of

[jira] [Updated] (CALCITE-3535) EnumerableJoinRule: remove unnecessary Filter on top of INNER Join

2019-11-25 Thread Ruben Q L (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-3535?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Ruben Q L updated CALCITE-3535: --- Description: With the implementation of CALCITE-2973, now EnumerableHashJoin supports all type of

[jira] [Updated] (CALCITE-3535) EnumerableJoinRule: remove unnecessary Filter on top of INNER Join

2019-11-25 Thread Ruben Q L (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-3535?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Ruben Q L updated CALCITE-3535: --- Description: With the implementation of CALCITE-2973, now EnumerableHashJoin supports all type of

[jira] [Created] (CALCITE-3535) EnumerableJoinRule: remove unnecessary Filter on top of INNER Join

2019-11-25 Thread Ruben Q L (Jira)
Ruben Q L created CALCITE-3535: -- Summary: EnumerableJoinRule: remove unnecessary Filter on top of INNER Join Key: CALCITE-3535 URL: https://issues.apache.org/jira/browse/CALCITE-3535 Project: Calcite

[jira] [Resolved] (CALCITE-3534) Support parse(unparse) alien system non-standard data type

2019-11-25 Thread Danny Chen (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-3534?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Danny Chen resolved CALCITE-3534. - Resolution: Fixed Fixed in

[jira] [Closed] (CALCITE-3511) Failed to serialize SqlNode to json string using jackson

2019-11-25 Thread groobyming (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-3511?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] groobyming closed CALCITE-3511. --- Fix Version/s: 1.21.0 Resolution: Not A Problem > Failed to serialize SqlNode to json