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

[ https://issues.apache.org/jira/browse/CALCITE-3741?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17017763#comment-17017763 ] Danny Chen commented on CALCITE-3741: - Take this PR

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

[ https://issues.apache.org/jira/browse/CALCITE-3731?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17017760#comment-17017760 ] Stamatis Zampetakis commented on CALCITE-3731: -- Such conversions are done via

[jira] [Closed] (CALCITE-3743) Implement PERCENT_RANK window aggregate function

[ https://issues.apache.org/jira/browse/CALCITE-3743?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Rui Wang closed CALCITE-3743. - Resolution: Duplicate > Implement PERCENT_RANK window aggregate function >

[jira] [Commented] (CALCITE-3743) Implement PERCENT_RANK window aggregate function

[ https://issues.apache.org/jira/browse/CALCITE-3743?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17017709#comment-17017709 ] Rui Wang commented on CALCITE-3743: --- Thanks [~donnyzone]. Will close this Jira.  > Implement

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

[ https://issues.apache.org/jira/browse/CALCITE-3741?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17017679#comment-17017679 ] james601232 commented on CALCITE-3741: -- Dear [~danny0405]  yes. ur right. could you give  me a

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

[ https://issues.apache.org/jira/browse/CALCITE-3741?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17017676#comment-17017676 ] Danny Chen commented on CALCITE-3741: - I kind of know what happens, it is not the SqlParser, but

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

[ https://issues.apache.org/jira/browse/CALCITE-3741?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17017668#comment-17017668 ] james601232 commented on CALCITE-3741: -- Dear [~icshuo]          type sql is "select * from

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

[ https://issues.apache.org/jira/browse/CALCITE-3741?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] james601232 updated CALCITE-3741: - Attachment: image-2020-01-17-10-43-28-765.png > duplicate ‘ordre by‘ key word generate in

[jira] [Commented] (CALCITE-3743) Implement PERCENT_RANK window aggregate function

[ https://issues.apache.org/jira/browse/CALCITE-3743?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17017667#comment-17017667 ] Feng Zhu commented on CALCITE-3743: --- It duplicates with CALCITE-2414. > Implement PERCENT_RANK

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

[ https://issues.apache.org/jira/browse/CALCITE-3741?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17017651#comment-17017651 ] Shuo Cheng commented on CALCITE-3741: - Hi, James, it would be more clear if you can just paste the

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

[ https://issues.apache.org/jira/browse/CALCITE-3732?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17017640#comment-17017640 ] Julian Hyde commented on CALCITE-3732: -- I'm not sure Oracle has all of those functions in SQL. The

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

[ https://issues.apache.org/jira/browse/CALCITE-3741?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17017638#comment-17017638 ] james601232 commented on CALCITE-3741: -- Dear [~amaliujia]         we  have a open project

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

[ https://issues.apache.org/jira/browse/CALCITE-3741?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] james601232 updated CALCITE-3741: - Attachment: image-2020-01-17-09-40-47-906.png > duplicate ‘ordre by‘ key word generate in

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

[ https://issues.apache.org/jira/browse/CALCITE-3741?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] james601232 updated CALCITE-3741: - Comment: was deleted (was: Dear [~amaliujia]) > duplicate ‘ordre by‘ key word generate in

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

[ https://issues.apache.org/jira/browse/CALCITE-3741?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17017630#comment-17017630 ] james601232 commented on CALCITE-3741: -- Dear [~amaliujia]  > duplicate ‘ordre by‘ key word

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

[ https://issues.apache.org/jira/browse/CALCITE-3741?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17017631#comment-17017631 ] james601232 commented on CALCITE-3741: -- Dear [~amaliujia] > duplicate ‘ordre by‘ key word

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

[ https://issues.apache.org/jira/browse/CALCITE-3741?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] james601232 updated CALCITE-3741: - Comment: was deleted (was: Dear [~amaliujia] ) > duplicate ‘ordre by‘ key word generate in

[jira] [Commented] (CALCITE-3721) Filter of distinct aggregate call is lost after applying `AggregateExpandDistinctAggregatesRule`

[ https://issues.apache.org/jira/browse/CALCITE-3721?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17017624#comment-17017624 ] Danny Chen commented on CALCITE-3721: - bq. filters tend to behave similarly to arguments to

[jira] [Created] (CALCITE-3744) Duplicate RuleMatches when RelSet gets merged

Haisheng Yuan created CALCITE-3744: -- Summary: Duplicate RuleMatches when RelSet gets merged Key: CALCITE-3744 URL: https://issues.apache.org/jira/browse/CALCITE-3744 Project: Calcite Issue

[jira] [Updated] (CALCITE-3743) Implement PERCENT_RANK window aggregate function

[ https://issues.apache.org/jira/browse/CALCITE-3743?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Rui Wang updated CALCITE-3743: -- Summary: Implement PERCENT_RANK window aggregate function (was: Support PERCENT_RANK window

[jira] [Commented] (CALCITE-3743) Support PERCENT_RANK window aggregate function

[ https://issues.apache.org/jira/browse/CALCITE-3743?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17017475#comment-17017475 ] Rui Wang commented on CALCITE-3743: --- It turns out that Calcite supports percent_rank in parser (and

[jira] [Updated] (CALCITE-3743) Support PERCENT_RANK window aggregate function

[ https://issues.apache.org/jira/browse/CALCITE-3743?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Rui Wang updated CALCITE-3743: -- Issue Type: Bug (was: Task) > Support PERCENT_RANK window aggregate function >

[jira] [Comment Edited] (CALCITE-3743) Support PERCENT_RANK window aggregate function

[ https://issues.apache.org/jira/browse/CALCITE-3743?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17017445#comment-17017445 ] Rui Wang edited comment on CALCITE-3743 at 1/16/20 8:17 PM: Question: which

[jira] [Commented] (CALCITE-3743) Support PERCENT_RANK window aggregate function

[ https://issues.apache.org/jira/browse/CALCITE-3743?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17017445#comment-17017445 ] Rui Wang commented on CALCITE-3743: --- Question: which class is the place to test such implementation?

[jira] [Updated] (CALCITE-3743) Support PERCENT_RANK window aggregate function

[ https://issues.apache.org/jira/browse/CALCITE-3743?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Rui Wang updated CALCITE-3743: -- Description: It seems like Calcite does not have an implementation of PERCENT_RANK: see the list of

[jira] [Created] (CALCITE-3743) Support PERCENT_RANK window aggregate function

Rui Wang created CALCITE-3743: - Summary: Support PERCENT_RANK window aggregate function Key: CALCITE-3743 URL: https://issues.apache.org/jira/browse/CALCITE-3743 Project: Calcite Issue Type:

[jira] [Commented] (CALCITE-3721) Filter of distinct aggregate call is lost after applying `AggregateExpandDistinctAggregatesRule`

[ https://issues.apache.org/jira/browse/CALCITE-3721?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17017416#comment-17017416 ] Julian Hyde commented on CALCITE-3721: -- The fix adds a lot more complexity than I had been

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

[ https://issues.apache.org/jira/browse/CALCITE-3738?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17017399#comment-17017399 ] Haisheng Yuan commented on CALCITE-3738: Now I think it may not harm to keep ordering.

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

[ https://issues.apache.org/jira/browse/CALCITE-3741?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17017365#comment-17017365 ] Rui Wang commented on CALCITE-3741: --- [~james601232] it could be very helpful if you share your test

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

[ https://issues.apache.org/jira/browse/CALCITE-3738?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17017362#comment-17017362 ] Rui Wang commented on CALCITE-3738: --- Move some discussions from PR to this thread:   I understand

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

[ https://issues.apache.org/jira/browse/CALCITE-3731?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17017347#comment-17017347 ] Rui Wang edited comment on CALCITE-3731 at 1/16/20 5:50 PM: Agreed with all

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

[ https://issues.apache.org/jira/browse/CALCITE-3731?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17017347#comment-17017347 ] Rui Wang commented on CALCITE-3731: --- Agreed with all above.  IF, CASE and Coalesce can all be

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

[ https://issues.apache.org/jira/browse/CALCITE-3731?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17017347#comment-17017347 ] Rui Wang edited comment on CALCITE-3731 at 1/16/20 5:48 PM: Agreed with all

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

[ https://issues.apache.org/jira/browse/CALCITE-3676?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17017342#comment-17017342 ] Xiening Dai commented on CALCITE-3676: -- Ok, that is a good workaround for now. I am using our own

[jira] [Commented] (CALCITE-3328) Immutable beans, powered by reflection

[ https://issues.apache.org/jira/browse/CALCITE-3328?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17016907#comment-17016907 ] Vladimir Sitnikov commented on CALCITE-3328: [~julianhyde], it seems to cause test failures

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

[ https://issues.apache.org/jira/browse/CALCITE-3732?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17016880#comment-17016880 ] hailong wang edited comment on CALCITE-3732 at 1/16/20 12:51 PM: -

[jira] [Resolved] (CALCITE-3742) Update Gradle: 6.0.1 -> 6.1

[ https://issues.apache.org/jira/browse/CALCITE-3742?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Vladimir Sitnikov resolved CALCITE-3742. Fix Version/s: avatica-1.17.0 1.22.0 Resolution: Fixed

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

[ https://issues.apache.org/jira/browse/CALCITE-3732?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17016880#comment-17016880 ] hailong wang commented on CALCITE-3732: --- Thanks [~julianhyde] [~amaliujia]. I conclude as

[jira] [Updated] (CALCITE-3742) Update Gradle: 6.0.1 -> 6.1

[ https://issues.apache.org/jira/browse/CALCITE-3742?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Vladimir Sitnikov updated CALCITE-3742: --- Affects Version/s: avatica-1.16.0 > Update Gradle: 6.0.1 -> 6.1 >

[jira] [Created] (CALCITE-3742) Update Gradle: 6.0.1 -> 6.1

Vladimir Sitnikov created CALCITE-3742: -- Summary: Update Gradle: 6.0.1 -> 6.1 Key: CALCITE-3742 URL: https://issues.apache.org/jira/browse/CALCITE-3742 Project: Calcite Issue Type:

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

[ https://issues.apache.org/jira/browse/CALCITE-3732?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] hailong wang reassigned CALCITE-3732: - Assignee: hailong wang > Implement bit functions and operators >

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

[ https://issues.apache.org/jira/browse/CALCITE-3731?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17016823#comment-17016823 ] Jin Xing commented on CALCITE-3731: --- [~vaibhavjain-dm] You can refer to 

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

[ https://issues.apache.org/jira/browse/CALCITE-3676?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17016778#comment-17016778 ] Vladimir Sitnikov commented on CALCITE-3676: [~xndai], Do you have a reproducible example

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

[ https://issues.apache.org/jira/browse/CALCITE-1861?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17016774#comment-17016774 ] Julian Hyde commented on CALCITE-1861: -- [~txy2539], I have now rebased my

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

[ https://issues.apache.org/jira/browse/CALCITE-1861?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Julian Hyde updated CALCITE-1861: - Labels: (was: gsoc2018) > Spatial Indexes > --- > > Key:

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

[ https://issues.apache.org/jira/browse/CALCITE-3735?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17016292#comment-17016292 ] Julian Hyde edited comment on CALCITE-3735 at 1/16/20 9:36 AM: --- Yes, I

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

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

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

[ https://issues.apache.org/jira/browse/CALCITE-3741?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17016719#comment-17016719 ] Danny Chen commented on CALCITE-3741: - How did you test that ? I use the "select * from products

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

[ https://issues.apache.org/jira/browse/CALCITE-3741?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17016699#comment-17016699 ] james601232 commented on CALCITE-3741: -- Dear [~danny0405]         my sql is “select * from

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

[ https://issues.apache.org/jira/browse/CALCITE-3741?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17016698#comment-17016698 ] james601232 commented on CALCITE-3741: -- Dear [~danny0405]    > duplicate ‘ordre by‘ key word

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

[ https://issues.apache.org/jira/browse/CALCITE-3741?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] james601232 updated CALCITE-3741: - Comment: was deleted (was: Dear [~danny0405]   ) > duplicate ‘ordre by‘ key word generate in

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

[ https://issues.apache.org/jira/browse/CALCITE-3741?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17016659#comment-17016659 ] Danny Chen commented on CALCITE-3741: - Why you write multiple "order by"s in your query, i tried