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

2020-01-15 Thread Danny Chen (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-3594?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17015710#comment-17015710 ] Danny Chen commented on CALCITE-3594: - Support a literal is not that easy, because we need to think

[jira] [Commented] (CALCITE-3731) Add IF function for BigQuery, Hive and Spark Dialects

2020-01-15 Thread Feng Zhu (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-3731?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17015739#comment-17015739 ] Feng Zhu commented on CALCITE-3731: --- Agree with [~zabetak], *IF* function's logic is the same as that

[jira] [Updated] (CALCITE-3738) Missing order by logical plan for insert statement

2020-01-15 Thread pengzhiwei (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-3738?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] pengzhiwei updated CALCITE-3738: Description: The following sql statement generates a wrong logical plan which missing the

[jira] [Updated] (CALCITE-3738) Missing order by logical plan for insert statement

2020-01-15 Thread ASF GitHub Bot (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-3738?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] ASF GitHub Bot updated CALCITE-3738: Labels: pull-request-available (was: ) > Missing order by logical plan for insert

[jira] [Commented] (CALCITE-3732) Implement bit functions and operators

2020-01-15 Thread Julian Hyde (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-3732?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17016235#comment-17016235 ] Julian Hyde commented on CALCITE-3732: -- I see that MySQL allows BIT_COUNT applied to binary

[jira] [Commented] (CALCITE-3676) VolcanoPlanner. dumpGraphviz should handle exception gracefully

2020-01-15 Thread Xiening Dai (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-3676?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17016185#comment-17016185 ] Xiening Dai commented on CALCITE-3676: -- Any progress on this, [~vladimirsitnikov] ? I have to

[jira] [Comment Edited] (CALCITE-3732) Implement bit functions and operators

2020-01-15 Thread Julian Hyde (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-3732?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17016235#comment-17016235 ] Julian Hyde edited comment on CALCITE-3732 at 1/15/20 7:12 PM: --- I see

[jira] [Commented] (CALCITE-3738) Missing order by logical plan for insert statement

2020-01-15 Thread Julian Hyde (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-3738?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17016249#comment-17016249 ] Julian Hyde commented on CALCITE-3738: -- By the way, please capitalize SQL keywords in JIRA case

[jira] [Comment Edited] (CALCITE-3738) Missing order by logical plan for insert statement

2020-01-15 Thread Julian Hyde (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-3738?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17016246#comment-17016246 ] Julian Hyde edited comment on CALCITE-3738 at 1/15/20 7:23 PM: --- I think

[jira] [Assigned] (CALCITE-3735) In ImmutableBeans, allow interfaces to have default methods

2020-01-15 Thread Julian Hyde (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-3735?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Julian Hyde reassigned CALCITE-3735: Assignee: Julian Hyde > In ImmutableBeans, allow interfaces to have default methods >

[jira] [Updated] (CALCITE-3735) In ImmutableBeans, allow interfaces to have default methods

2020-01-15 Thread Julian Hyde (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-3735?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Julian Hyde updated CALCITE-3735: - Fix Version/s: 1.22.0 > In ImmutableBeans, allow interfaces to have default methods >

[jira] [Comment Edited] (CALCITE-3732) Implement bit functions and operators

2020-01-15 Thread Julian Hyde (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-3732?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17016235#comment-17016235 ] Julian Hyde edited comment on CALCITE-3732 at 1/15/20 7:04 PM: --- I see

[jira] [Commented] (CALCITE-3738) Missing order by logical plan for insert statement

2020-01-15 Thread Julian Hyde (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-3738?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17016246#comment-17016246 ] Julian Hyde commented on CALCITE-3738: -- However, if there is LIMIT or OFFSET, we should allow

[jira] [Commented] (CALCITE-3738) Missing order by logical plan for insert statement

2020-01-15 Thread Julian Hyde (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-3738?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17016244#comment-17016244 ] Julian Hyde commented on CALCITE-3738: -- It depends how you define sub-query. It is a query that is

[jira] [Commented] (CALCITE-3735) In ImmutableBeans, allow interfaces to have default methods

2020-01-15 Thread Andrei Sereda (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-3735?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17016270#comment-17016270 ] Andrei Sereda commented on CALCITE-3735: Yes, seems like calling interface default methods

[jira] [Commented] (CALCITE-3734) MySQL JDBC rewrite is producing queries with CHAR with range beyond 255

2020-01-15 Thread Julian Hyde (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-3734?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17016269#comment-17016269 ] Julian Hyde commented on CALCITE-3734: -- The 255 limit for CHAR is MySQL-specific (Vertica, for

[jira] [Commented] (CALCITE-1861) Spatial Indexes

2020-01-15 Thread Michael Mior (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-1861?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17016354#comment-17016354 ] Michael Mior commented on CALCITE-1861: --- [~julianhyde] I have a student working with me this

[jira] [Commented] (CALCITE-3735) In ImmutableBeans, allow interfaces to have default methods

2020-01-15 Thread Julian Hyde (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-3735?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17016292#comment-17016292 ] Julian Hyde commented on CALCITE-3735: -- Yes, I saw that. In

[jira] [Commented] (CALCITE-3732) Implement bit functions and operators

2020-01-15 Thread Rui Wang (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-3732?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17016310#comment-17016310 ] Rui Wang commented on CALCITE-3732: --- Julian had already have a great summary for some functions.

[jira] [Updated] (CALCITE-3741) duplicate ‘ordre by‘ key word generate in select

2020-01-15 Thread james601232 (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-3741?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] james601232 updated CALCITE-3741: - Summary: duplicate ‘ordre by‘ key word generate in select (was: duplicate ‘ordre by‘ key work

[jira] [Created] (CALCITE-3741) duplicate ‘ordre by‘ key work generate in select

2020-01-15 Thread james601232 (Jira)
james601232 created CALCITE-3741: Summary: duplicate ‘ordre by‘ key work generate in select Key: CALCITE-3741 URL: https://issues.apache.org/jira/browse/CALCITE-3741 Project: Calcite Issue

[jira] [Commented] (CALCITE-3738) Missing LogicalSort for insert statement

2020-01-15 Thread pengzhiwei (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-3738?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17016606#comment-17016606 ] pengzhiwei commented on CALCITE-3738: -    I think the SQL  is not fully equivalent to the generated

[jira] [Comment Edited] (CALCITE-3738) Missing LogicalSort for insert statement

2020-01-15 Thread pengzhiwei (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-3738?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17016606#comment-17016606 ] pengzhiwei edited comment on CALCITE-3738 at 1/16/20 7:12 AM: --   Hi

[jira] [Reopened] (CALCITE-3738) Missing LogicalSort for insert statement

2020-01-15 Thread pengzhiwei (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-3738?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] pengzhiwei reopened CALCITE-3738: - > Missing LogicalSort for insert statement > > >

[jira] [Updated] (CALCITE-3738) Missing LogicalSort for insert statement

2020-01-15 Thread pengzhiwei (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-3738?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] pengzhiwei updated CALCITE-3738: Summary: Missing LogicalSort for insert statement (was: Missing Order logical plan for insert

[jira] [Comment Edited] (CALCITE-3738) Missing LogicalSort for insert statement

2020-01-15 Thread pengzhiwei (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-3738?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17016606#comment-17016606 ] pengzhiwei edited comment on CALCITE-3738 at 1/16/20 7:10 AM: --    I think

[jira] [Comment Edited] (CALCITE-3738) Missing LogicalSort for insert statement

2020-01-15 Thread pengzhiwei (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-3738?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17016606#comment-17016606 ] pengzhiwei edited comment on CALCITE-3738 at 1/16/20 7:12 AM: --   Hi

[jira] [Updated] (CALCITE-3738) Missing LogicalSort for Insert statement

2020-01-15 Thread pengzhiwei (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-3738?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] pengzhiwei updated CALCITE-3738: Summary: Missing LogicalSort for Insert statement (was: Missing LogicalSort for insert

[jira] [Commented] (CALCITE-3739) Remove failed snapshot track file in Windows OS for Cassandra adapter

2020-01-15 Thread Feng Zhu (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-3739?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17016485#comment-17016485 ] Feng Zhu commented on CALCITE-3739: --- I put Calcite project in my disk F. The full path is:

[jira] [Commented] (CALCITE-3739) Remove failed snapshot track file in Windows OS for Cassandra adapter

2020-01-15 Thread Andrei Sereda (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-3739?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17016480#comment-17016480 ] Andrei Sereda commented on CALCITE-3739: What is the full path to {{f}} ? {code:java}

[jira] [Commented] (CALCITE-1861) Spatial Indexes

2020-01-15 Thread Julian Hyde (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-1861?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17016385#comment-17016385 ] Julian Hyde commented on CALCITE-1861: -- [~mmior], I got a lot of it working in my branch

[jira] [Commented] (CALCITE-3739) Remove failed snapshot track file in Windows OS for Cassandra adapter

2020-01-15 Thread Feng Zhu (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-3739?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17016475#comment-17016475 ] Feng Zhu commented on CALCITE-3739: --- Hi [~sereda], When I found that

[jira] [Commented] (CALCITE-3739) Remove failed snapshot track file in Windows OS for Cassandra adapter

2020-01-15 Thread Andrei Sereda (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-3739?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17016425#comment-17016425 ] Andrei Sereda commented on CALCITE-3739: [~donnyzone] this PR was not yet merged.   Let me

[jira] [Commented] (CALCITE-3739) Remove failed snapshot track file in Windows OS for Cassandra adapter

2020-01-15 Thread Andrei Sereda (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-3739?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17016440#comment-17016440 ] Andrei Sereda commented on CALCITE-3739: [~donnyzone] do you have a stack trace with locked

[jira] [Commented] (CALCITE-1861) Spatial Indexes

2020-01-15 Thread Tao Yang (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-1861?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17016389#comment-17016389 ] Tao Yang commented on CALCITE-1861: --- Hi, I am Tao Yang, a student of Michael Mior. I am interested in

[jira] [Resolved] (CALCITE-3738) Missing order by logical plan for insert statement

2020-01-15 Thread Haisheng Yuan (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-3738?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Haisheng Yuan resolved CALCITE-3738. Resolution: Not A Problem I agree with [~julianhyde]. Calcite is doing right. We allow

[jira] [Resolved] (CALCITE-3736) Add an interface in RelOptRuleCall to customize the propagation of hints before registering into planner rule

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