[jira] [Commented] (CALCITE-3387) Query with GROUP BY and JOIN ... USING wrongly fails with "Column 'DEPTNO' is ambiguous" error

2019-12-19 Thread Chunwei Lei (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-3387?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16999836#comment-16999836 ] Chunwei Lei commented on CALCITE-3387: -- Thanks for your review, [~jinxing6...@126.

[jira] [Resolved] (CALCITE-3568) BigQuery, Hive, Spark SQL dialect don't support nested aggregates

2019-12-19 Thread Chunwei Lei (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-3568?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Chunwei Lei resolved CALCITE-3568. -- Resolution: Fixed Fixed in  [https://github.com/apache/calcite/commit/f3020bc59be668b36a13136

[jira] [Commented] (CALCITE-3606) batch insert failed

2019-12-19 Thread Ran Cao (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-3606?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16999883#comment-16999883 ] Ran Cao commented on CALCITE-3606: -- {code:java} final RelToSqlConverter converter = ne

[jira] [Updated] (CALCITE-3591) Add BIT_XOR BIT aggregate function

2019-12-19 Thread ASF GitHub Bot (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-3591?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] ASF GitHub Bot updated CALCITE-3591: Labels: pull-request-available (was: ) > Add BIT_XOR BIT aggregate function > --

[jira] [Commented] (CALCITE-3603) SqlLateralOperator's unparse add additional keyword 'LATERAL' when the inner operator is SqlSnapshot

2019-12-19 Thread Julian Hyde (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-3603?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17000342#comment-17000342 ] Julian Hyde commented on CALCITE-3603: -- I don't see why a temporal table join shou

[jira] [Commented] (CALCITE-3594) Support hot Groupby keys hint

2019-12-19 Thread Rui Wang (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-3594?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17000404#comment-17000404 ] Rui Wang commented on CALCITE-3594: --- [~danny0405] thanks! I revise a bit on you sugg

[jira] [Commented] (CALCITE-3594) Support hot Groupby keys hint

2019-12-19 Thread Danny Chen (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-3594?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17000551#comment-17000551 ] Danny Chen commented on CALCITE-3594: - Thanks [~amaliujia] Let's have a clear concl

[jira] [Comment Edited] (CALCITE-3594) Support hot Groupby keys hint

2019-12-19 Thread Danny Chen (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-3594?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17000551#comment-17000551 ] Danny Chen edited comment on CALCITE-3594 at 12/20/19 1:48 AM: --

[jira] [Created] (CALCITE-3611) Introduce TIME/TIMESTAMP WITH TIME ZONE types

2019-12-19 Thread Zhenghua Gao (Jira)
Zhenghua Gao created CALCITE-3611: - Summary: Introduce TIME/TIMESTAMP WITH TIME ZONE types Key: CALCITE-3611 URL: https://issues.apache.org/jira/browse/CALCITE-3611 Project: Calcite Issue Typ

[jira] [Created] (CALCITE-3612) Add TIME/TIMESTAMP WITH TIME ZONE in optimizer

2019-12-19 Thread Zhenghua Gao (Jira)
Zhenghua Gao created CALCITE-3612: - Summary: Add TIME/TIMESTAMP WITH TIME ZONE in optimizer Key: CALCITE-3612 URL: https://issues.apache.org/jira/browse/CALCITE-3612 Project: Calcite Issue Ty

[jira] [Created] (CALCITE-3613) Support TIME/TIMESTAMP WITH TIME ZONE in Calcite SQL parser and builtin functions

2019-12-19 Thread Zhenghua Gao (Jira)
Zhenghua Gao created CALCITE-3613: - Summary: Support TIME/TIMESTAMP WITH TIME ZONE in Calcite SQL parser and builtin functions Key: CALCITE-3613 URL: https://issues.apache.org/jira/browse/CALCITE-3613

[jira] [Created] (CALCITE-3614) Support TIME/TIMESTAMP WITH TIME ZONE literals

2019-12-19 Thread Zhenghua Gao (Jira)
Zhenghua Gao created CALCITE-3614: - Summary: Support TIME/TIMESTAMP WITH TIME ZONE literals Key: CALCITE-3614 URL: https://issues.apache.org/jira/browse/CALCITE-3614 Project: Calcite Issue Ty

[jira] [Created] (CALCITE-3615) Improve JDBC driver to support java.time classes

2019-12-19 Thread Zhenghua Gao (Jira)
Zhenghua Gao created CALCITE-3615: - Summary: Improve JDBC driver to support java.time classes Key: CALCITE-3615 URL: https://issues.apache.org/jira/browse/CALCITE-3615 Project: Calcite Issue

[jira] [Updated] (CALCITE-3615) Improve JDBC driver to support java.time classes

2019-12-19 Thread Zhenghua Gao (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-3615?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Zhenghua Gao updated CALCITE-3615: -- Component/s: jdbc-adapter > Improve JDBC driver to support java.time classes > --

[jira] [Updated] (CALCITE-3614) Support TIME/TIMESTAMP WITH TIME ZONE literals

2019-12-19 Thread Zhenghua Gao (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-3614?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Zhenghua Gao updated CALCITE-3614: -- Component/s: core > Support TIME/TIMESTAMP WITH TIME ZONE literals >

[jira] [Updated] (CALCITE-3611) Introduce TIME/TIMESTAMP WITH TIME ZONE types

2019-12-19 Thread Danny Chen (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-3611?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Danny Chen updated CALCITE-3611: Labels: timestamp (was: ) > Introduce TIME/TIMESTAMP WITH TIME ZONE types >

[jira] [Updated] (CALCITE-3611) Introduce TIME/TIMESTAMP WITH TIME ZONE types

2019-12-19 Thread Danny Chen (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-3611?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Danny Chen updated CALCITE-3611: Component/s: core > Introduce TIME/TIMESTAMP WITH TIME ZONE types > -

[jira] [Updated] (CALCITE-3611) Introduce TIME/TIMESTAMP WITH TIME ZONE types

2019-12-19 Thread Danny Chen (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-3611?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Danny Chen updated CALCITE-3611: Affects Version/s: 1.21.0 > Introduce TIME/TIMESTAMP WITH TIME ZONE types > -

[jira] [Resolved] (CALCITE-3595) Test infrastructure overwrites reference log with wrong results

2019-12-19 Thread Danny Chen (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-3595?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Danny Chen resolved CALCITE-3595. - Fix Version/s: 1.22.0 Assignee: Danny Chen Resolution: Fixed Fixed in [edc386d

[jira] [Created] (CALCITE-3616) Add BOOL_AND Aggregate Function

2019-12-19 Thread Ritesh (Jira)
Ritesh created CALCITE-3616: --- Summary: Add BOOL_AND Aggregate Function Key: CALCITE-3616 URL: https://issues.apache.org/jira/browse/CALCITE-3616 Project: Calcite Issue Type: New Feature

[jira] [Created] (CALCITE-3617) Add BOOL_OR Aggregate Function

2019-12-19 Thread Ritesh (Jira)
Ritesh created CALCITE-3617: --- Summary: Add BOOL_OR Aggregate Function Key: CALCITE-3617 URL: https://issues.apache.org/jira/browse/CALCITE-3617 Project: Calcite Issue Type: New Feature

[jira] [Updated] (CALCITE-3617) Add BOOL_OR Aggregate Function

2019-12-19 Thread Ritesh (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-3617?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Ritesh updated CALCITE-3617: Description: [https://docs.aws.amazon.com/redshift/latest/dg/r_BOOL_OR.html] > Add BOOL_OR Aggregate Func

[jira] [Commented] (CALCITE-3387) Query with GROUP BY and JOIN ... USING wrongly fails with "Column 'DEPTNO' is ambiguous" error

2019-12-19 Thread Jin Xing (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-3387?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17000630#comment-17000630 ] Jin Xing commented on CALCITE-3387: --- Thanks for ping me, Chunwei ~ I just added mino

[jira] [Commented] (CALCITE-3603) SqlLateralOperator's unparse add additional keyword 'LATERAL' when the inner operator is SqlSnapshot

2019-12-19 Thread Danny Chen (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-3603?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17000635#comment-17000635 ] Danny Chen commented on CALCITE-3603: - Thanks [~julianhyde] ~ I did a little resear

[jira] [Comment Edited] (CALCITE-3603) SqlLateralOperator's unparse add additional keyword 'LATERAL' when the inner operator is SqlSnapshot

2019-12-19 Thread Danny Chen (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-3603?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17000635#comment-17000635 ] Danny Chen edited comment on CALCITE-3603 at 12/20/19 5:48 AM: --

[jira] [Comment Edited] (CALCITE-3603) SqlLateralOperator's unparse add additional keyword 'LATERAL' when the inner operator is SqlSnapshot

2019-12-19 Thread Danny Chen (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-3603?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17000635#comment-17000635 ] Danny Chen edited comment on CALCITE-3603 at 12/20/19 6:07 AM: --

[jira] [Commented] (CALCITE-3611) Introduce TIME/TIMESTAMP WITH TIME ZONE types

2019-12-19 Thread Rui Wang (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-3611?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17000674#comment-17000674 ] Rui Wang commented on CALCITE-3611: --- Hi Zhenghua, I find this type is also useful for

[jira] [Assigned] (CALCITE-3415) Supports REGEXP_SUBSTR function

2019-12-19 Thread Pranay Parmar (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-3415?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Pranay Parmar reassigned CALCITE-3415: -- Assignee: Pranay Parmar (was: Danny Chen) > Supports REGEXP_SUBSTR function > -