[jira] [Created] (CALCITE-2658) Introducing more ReduceExpressionRules

Chunwei Lei created CALCITE-2658: Summary: Introducing more ReduceExpressionRules Key: CALCITE-2658 URL: https://issues.apache.org/jira/browse/CALCITE-2658 Project: Calcite Issue Type: Bug

[jira] [Created] (CALCITE-2657) use RexCall#clone instead of constructor to make a new RexCall in RexShuttle for more scalability

Chunwei Lei created CALCITE-2657: Summary: use RexCall#clone instead of constructor to make a new RexCall in RexShuttle for more scalability Key: CALCITE-2657 URL:

[jira] [Commented] (CALCITE-2661) RelBuilder supports creating Exchange and SortExchange

[ https://issues.apache.org/jira/browse/CALCITE-2661?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16679236#comment-16679236 ] Chunwei Lei commented on CALCITE-2661: -- I would like to work on this issue. > RelBuilder

[jira] [Commented] (CALCITE-2658) Introducing more ReduceExpressionRules

[ https://issues.apache.org/jira/browse/CALCITE-2658?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16679203#comment-16679203 ] Chunwei Lei commented on CALCITE-2658: -- Thanks [~julianhyde] I will create another jira to

[jira] [Created] (CALCITE-2661) support creating Exchange and SortExchange in RelBuilder

Chunwei Lei created CALCITE-2661: Summary: support creating Exchange and SortExchange in RelBuilder Key: CALCITE-2661 URL: https://issues.apache.org/jira/browse/CALCITE-2661 Project: Calcite

[jira] [Updated] (CALCITE-2661) RelBuilder supports creating Exchange and SortExchange

[ https://issues.apache.org/jira/browse/CALCITE-2661?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Chunwei Lei updated CALCITE-2661: - Summary: RelBuilder supports creating Exchange and SortExchange (was: support creating

[jira] [Commented] (CALCITE-2661) RelBuilder supports creating Exchange and SortExchange

[ https://issues.apache.org/jira/browse/CALCITE-2661?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16680814#comment-16680814 ] Chunwei Lei commented on CALCITE-2661: -- I have created a PR:

[jira] [Comment Edited] (CALCITE-2661) RelBuilder supports creating Exchange and SortExchange

[ https://issues.apache.org/jira/browse/CALCITE-2661?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16680814#comment-16680814 ] Chunwei Lei edited comment on CALCITE-2661 at 11/9/18 4:09 AM: ---

[jira] [Commented] (CALCITE-2658) Introducing more ReduceExpressionRules

[ https://issues.apache.org/jira/browse/CALCITE-2658?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16682758#comment-16682758 ] Chunwei Lei commented on CALCITE-2658: -- Hi, [~julianhyde] I have submitted an extra PR for

[jira] [Comment Edited] (CALCITE-2658) Introducing more ReduceExpressionRules

[ https://issues.apache.org/jira/browse/CALCITE-2658?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16679203#comment-16679203 ] Chunwei Lei edited comment on CALCITE-2658 at 11/13/18 6:09 AM: Thanks

[jira] [Commented] (CALCITE-2661) RelBuilder supports creating Exchange and SortExchange

[ https://issues.apache.org/jira/browse/CALCITE-2661?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16683723#comment-16683723 ] Chunwei Lei commented on CALCITE-2661: -- [~julianhyde] Thank you for your review. I updated the PR

[jira] [Commented] (CALCITE-2658) Introducing more ReduceExpressionRules

[ https://issues.apache.org/jira/browse/CALCITE-2658?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16688058#comment-16688058 ] Chunwei Lei commented on CALCITE-2658: -- [~julianhyde] Sorry for the late reply. Does using traits

[jira] [Commented] (CALCITE-2657) use RexCall#clone instead of constructor to make a new RexCall in RexShuttle for more scalability

[ https://issues.apache.org/jira/browse/CALCITE-2657?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16677938#comment-16677938 ] Chunwei Lei commented on CALCITE-2657: -- Thanks [~julianhyde] > use RexCall#clone instead of

[jira] [Closed] (CALCITE-2657) use RexCall#clone instead of constructor to make a new RexCall in RexShuttle for more scalability

[ https://issues.apache.org/jira/browse/CALCITE-2657?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Chunwei Lei closed CALCITE-2657. Resolution: Not A Bug > use RexCall#clone instead of constructor to make a new RexCall in

[jira] [Comment Edited] (CALCITE-2657) use RexCall#clone instead of constructor to make a new RexCall in RexShuttle for more scalability

[ https://issues.apache.org/jira/browse/CALCITE-2657?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16677938#comment-16677938 ] Chunwei Lei edited comment on CALCITE-2657 at 11/7/18 9:59 AM: --- Got it!

[jira] [Updated] (CALCITE-2657) use RexCall#clone instead of constructor to make a new RexCall in RexShuttle for more scalability

[ https://issues.apache.org/jira/browse/CALCITE-2657?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Chunwei Lei updated CALCITE-2657: - Description: RexShuttle uses constructor of RexCall to generate a new RexCall, as followings:

[jira] [Commented] (CALCITE-2657) use RexCall#clone instead of constructor to make a new RexCall in RexShuttle for more scalability

[ https://issues.apache.org/jira/browse/CALCITE-2657?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16677826#comment-16677826 ] Chunwei Lei commented on CALCITE-2657: -- It is not a performance issue. In our use case, we use

[jira] [Commented] (CALCITE-2658) Introducing more ReduceExpressionRules

[ https://issues.apache.org/jira/browse/CALCITE-2658?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16677838#comment-16677838 ] Chunwei Lei commented on CALCITE-2658: -- Thanks Stamatis Zampetakis. SortRemoveConstantKeysRule

[jira] [Reopened] (CALCITE-2657) use RexCall#clone instead of constructor to make a new RexCall in RexShuttle for more scalability

[ https://issues.apache.org/jira/browse/CALCITE-2657?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Chunwei Lei reopened CALCITE-2657: -- > use RexCall#clone instead of constructor to make a new RexCall in RexShuttle > for more

[jira] [Assigned] (CALCITE-2729) Introducing WindowExpressionRules

[ https://issues.apache.org/jira/browse/CALCITE-2729?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Chunwei Lei reassigned CALCITE-2729: Assignee: Julian Hyde (was: Chunwei Lei) > Introducing WindowExpressionRules >

[jira] [Commented] (CALCITE-2658) Introducing more ReduceExpressionRules

[ https://issues.apache.org/jira/browse/CALCITE-2658?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16745741#comment-16745741 ] Chunwei Lei commented on CALCITE-2658: -- Hi [~julianhyde] Do you or someone else have any plan on

[jira] [Commented] (CALCITE-2729) Introducing WindowExpressionRules

[ https://issues.apache.org/jira/browse/CALCITE-2729?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16712312#comment-16712312 ] Chunwei Lei commented on CALCITE-2729: -- I have submitted an extra PR for introducing

[jira] [Comment Edited] (CALCITE-2658) Introducing more ReduceExpressionRules

[ https://issues.apache.org/jira/browse/CALCITE-2658?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16712309#comment-16712309 ] Chunwei Lei edited comment on CALCITE-2658 at 12/7/18 5:08 AM: --- Thanks

[jira] [Commented] (CALCITE-2658) Introducing more ReduceExpressionRules

[ https://issues.apache.org/jira/browse/CALCITE-2658?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16712420#comment-16712420 ] Chunwei Lei commented on CALCITE-2658: -- [~julianhyde] I updated

[jira] [Updated] (CALCITE-2729) Introducing WindowExpressionRules

[ https://issues.apache.org/jira/browse/CALCITE-2729?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Chunwei Lei updated CALCITE-2729: - Description: Introducing WindowExpressionRules, for example: select sum(sal) over (partition

[jira] [Comment Edited] (CALCITE-2658) Introducing more ReduceExpressionRules

[ https://issues.apache.org/jira/browse/CALCITE-2658?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16712309#comment-16712309 ] Chunwei Lei edited comment on CALCITE-2658 at 12/7/18 3:57 AM: --- Thanks

[jira] [Created] (CALCITE-2729) Introducing WindowExpressionRules

Chunwei Lei created CALCITE-2729: Summary: Introducing WindowExpressionRules Key: CALCITE-2729 URL: https://issues.apache.org/jira/browse/CALCITE-2729 Project: Calcite Issue Type: Bug

[jira] [Comment Edited] (CALCITE-2658) Introducing more ReduceExpressionRules

[ https://issues.apache.org/jira/browse/CALCITE-2658?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16712309#comment-16712309 ] Chunwei Lei edited comment on CALCITE-2658 at 12/7/18 5:07 AM: --- Thanks

[jira] [Updated] (CALCITE-2729) Introducing WindowExpressionRules

[ https://issues.apache.org/jira/browse/CALCITE-2729?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Chunwei Lei updated CALCITE-2729: - Description: Introducing WindowExpressionRules. Select was:Introducing

[jira] [Comment Edited] (CALCITE-2658) Introducing more ReduceExpressionRules

[ https://issues.apache.org/jira/browse/CALCITE-2658?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16712309#comment-16712309 ] Chunwei Lei edited comment on CALCITE-2658 at 12/7/18 8:46 AM: --- Thanks

[jira] [Commented] (CALCITE-2754) LISTAGG support

[ https://issues.apache.org/jira/browse/CALCITE-2754?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16807421#comment-16807421 ] Chunwei Lei commented on CALCITE-2754: -- I opened

[jira] [Commented] (CALCITE-1338) JoinProjectTransposeRule makes wrong transformation when the right child of left outer join has a RexLiteral project expression.

[ https://issues.apache.org/jira/browse/CALCITE-1338?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16807488#comment-16807488 ] Chunwei Lei commented on CALCITE-1338: -- I will take a look into this since it will cause data

[jira] [Commented] (CALCITE-683) String aggregates

[ https://issues.apache.org/jira/browse/CALCITE-683?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16807352#comment-16807352 ] Chunwei Lei commented on CALCITE-683: - Make sense. Thank you for explanation. > String aggregates >

[jira] [Comment Edited] (CALCITE-2754) LISTAGG support

[ https://issues.apache.org/jira/browse/CALCITE-2754?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16807421#comment-16807421 ] Chunwei Lei edited comment on CALCITE-2754 at 4/2/19 6:07 AM: -- I opened

[jira] [Resolved] (CALCITE-683) String aggregates

[ https://issues.apache.org/jira/browse/CALCITE-683?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Chunwei Lei resolved CALCITE-683. - Resolution: Duplicate > String aggregates > - > > Key:

[jira] [Commented] (CALCITE-2754) LISTAGG support

[ https://issues.apache.org/jira/browse/CALCITE-2754?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16807357#comment-16807357 ] Chunwei Lei commented on CALCITE-2754: -- [~Sergey Nuyanzin], Any progress on this? I would like to

[jira] [Comment Edited] (CALCITE-2754) LISTAGG support

[ https://issues.apache.org/jira/browse/CALCITE-2754?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16807421#comment-16807421 ] Chunwei Lei edited comment on CALCITE-2754 at 4/2/19 6:08 AM: -- I opened

[jira] [Commented] (CALCITE-883) Support RESPECT NULLS, IGNORE NULLS option for LEAD, LAG, FIRST_VALUE, LAST_VALUE and NTH_VALUE window functions

[ https://issues.apache.org/jira/browse/CALCITE-883?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16806324#comment-16806324 ] Chunwei Lei commented on CALCITE-883: - [~zhztheplayer], thank you for your kindly help.;) > Support

[jira] [Commented] (CALCITE-2964) testEmptyFilterProjectUnion fails when copyPorject is disabled in FilterProjectTransposeRule

[ https://issues.apache.org/jira/browse/CALCITE-2964?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16806333#comment-16806333 ] Chunwei Lei commented on CALCITE-2964: -- I debugged a little since it is a little weird. I find

[jira] [Comment Edited] (CALCITE-2964) testEmptyFilterProjectUnion fails when copyPorject is disabled in FilterProjectTransposeRule

[ https://issues.apache.org/jira/browse/CALCITE-2964?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16806333#comment-16806333 ] Chunwei Lei edited comment on CALCITE-2964 at 4/1/19 2:22 AM: -- I debugged

[jira] [Commented] (CALCITE-2965) Implement string functions: REPEAT, SPACE, SOUNDEX, DIFFERENCE

[ https://issues.apache.org/jira/browse/CALCITE-2965?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16808413#comment-16808413 ] Chunwei Lei commented on CALCITE-2965: -- {quote}SOUNDEX is not in the SQL standard and it's not – I

[jira] [Comment Edited] (CALCITE-2965) Implement string functions: REPEAT, SPACE, SOUNDEX, DIFFERENCE

[ https://issues.apache.org/jira/browse/CALCITE-2965?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16808387#comment-16808387 ] Chunwei Lei edited comment on CALCITE-2965 at 4/3/19 5:51 AM: --

[jira] [Commented] (CALCITE-1515) Support TableFunctionScan in RelBuilder

[ https://issues.apache.org/jira/browse/CALCITE-1515?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16808418#comment-16808418 ] Chunwei Lei commented on CALCITE-1515: -- Oops, sorry for that. > Support TableFunctionScan in

[jira] [Assigned] (CALCITE-2658) Introducing more ReduceExpressionRules

[ https://issues.apache.org/jira/browse/CALCITE-2658?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Chunwei Lei reassigned CALCITE-2658: Assignee: Chunwei Lei (was: Julian Hyde) > Introducing more ReduceExpressionRules >

[jira] [Commented] (CALCITE-883) RESPECT NULLS, IGNORE NULLS option for LEAD, LAG window functions

[ https://issues.apache.org/jira/browse/CALCITE-883?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16797756#comment-16797756 ] Chunwei Lei commented on CALCITE-883: - I am sorry that I don't mention the conflict in the PR. It is

[jira] [Comment Edited] (CALCITE-883) RESPECT NULLS, IGNORE NULLS option for LEAD, LAG window functions

[ https://issues.apache.org/jira/browse/CALCITE-883?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16797756#comment-16797756 ] Chunwei Lei edited comment on CALCITE-883 at 3/21/19 2:52 AM: -- I am sorry

[jira] [Commented] (CALCITE-1515) Support TableFunctionScan in RelBuilder

[ https://issues.apache.org/jira/browse/CALCITE-1515?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16797776#comment-16797776 ] Chunwei Lei commented on CALCITE-1515: -- [~julianhyde] Since you reviewed the PR and left some

[jira] [Assigned] (CALCITE-2908) Add LAST_DAY function

[ https://issues.apache.org/jira/browse/CALCITE-2908?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Chunwei Lei reassigned CALCITE-2908: Assignee: Chunwei Lei > Add LAST_DAY function > - > >

[jira] [Commented] (CALCITE-1299) Reference type of Pulled Up Predicates is not handled properly

[ https://issues.apache.org/jira/browse/CALCITE-1299?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16797816#comment-16797816 ] Chunwei Lei commented on CALCITE-1299: -- I test it in the latest version and it looks like it is

[jira] [Assigned] (CALCITE-2599) Support ASCII(string) in SqlFunctions

[ https://issues.apache.org/jira/browse/CALCITE-2599?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Chunwei Lei reassigned CALCITE-2599: Assignee: Chunwei Lei > Support ASCII(string) in SqlFunctions >

[jira] [Closed] (CALCITE-2599) Support ASCII(string) in SqlFunctions

[ https://issues.apache.org/jira/browse/CALCITE-2599?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Chunwei Lei closed CALCITE-2599. > Support ASCII(string) in SqlFunctions > - > >

[jira] [Closed] (CALCITE-2895) Some arguments are undocumented in constructor of LogicalAggregate

[ https://issues.apache.org/jira/browse/CALCITE-2895?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Chunwei Lei closed CALCITE-2895. > Some arguments are undocumented in constructor of LogicalAggregate >

[jira] [Assigned] (CALCITE-883) RESPECT NULLS, IGNORE NULLS option for LEAD, LAG window functions

[ https://issues.apache.org/jira/browse/CALCITE-883?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Chunwei Lei reassigned CALCITE-883: --- Assignee: Chunwei Lei (was: Sean Hsuan-Yi Chu) > RESPECT NULLS, IGNORE NULLS option for

[jira] [Assigned] (CALCITE-1515) Support TableFunctionScan in RelBuilder

[ https://issues.apache.org/jira/browse/CALCITE-1515?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Chunwei Lei reassigned CALCITE-1515: Assignee: Chunwei Lei > Support TableFunctionScan in RelBuilder >

[jira] [Assigned] (CALCITE-2895) Some arguments are undocumented in constructor of LogicalAggregate

[ https://issues.apache.org/jira/browse/CALCITE-2895?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Chunwei Lei reassigned CALCITE-2895: Assignee: Chunwei Lei > Some arguments are undocumented in constructor of

[jira] [Assigned] (CALCITE-2729) Introducing WindowExpressionRules

[ https://issues.apache.org/jira/browse/CALCITE-2729?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Chunwei Lei reassigned CALCITE-2729: Assignee: Chunwei Lei (was: Julian Hyde) > Introducing WindowExpressionRules >

[jira] [Commented] (CALCITE-883) Support RESPECT NULLS, IGNORE NULLS option for LEAD, LAG, FIRST_VALUE, LAST_VALUE window functions

[ https://issues.apache.org/jira/browse/CALCITE-883?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16801337#comment-16801337 ] Chunwei Lei commented on CALCITE-883: - Thank you for your work, [~zhztheplayer]. It is much more

[jira] [Commented] (CALCITE-883) RESPECT NULLS, IGNORE NULLS option for LEAD, LAG window functions

[ https://issues.apache.org/jira/browse/CALCITE-883?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16797921#comment-16797921 ] Chunwei Lei commented on CALCITE-883: - [~zhztheplayer] I really appreciate your patient analysis.

[jira] [Commented] (CALCITE-883) RESPECT NULLS, IGNORE NULLS option for LEAD, LAG window functions

[ https://issues.apache.org/jira/browse/CALCITE-883?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16798058#comment-16798058 ] Chunwei Lei commented on CALCITE-883: - Maybe I should say SqlOverOperator instead of RexOver. Let's

[jira] [Comment Edited] (CALCITE-883) Support RESPECT NULLS, IGNORE NULLS option for LEAD, LAG, FIRST_VALUE, LAST_VALUE window functions

[ https://issues.apache.org/jira/browse/CALCITE-883?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16800399#comment-16800399 ] Chunwei Lei edited comment on CALCITE-883 at 3/25/19 4:25 AM: --

[jira] [Assigned] (CALCITE-2712) Add rule to remove null-generating side of a Join

[ https://issues.apache.org/jira/browse/CALCITE-2712?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Chunwei Lei reassigned CALCITE-2712: Assignee: Chunwei Lei > Add rule to remove null-generating side of a Join >

[jira] [Commented] (CALCITE-883) Support RESPECT NULLS, IGNORE NULLS option for LEAD, LAG, FIRST_VALUE, LAST_VALUE window functions

[ https://issues.apache.org/jira/browse/CALCITE-883?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16800399#comment-16800399 ] Chunwei Lei commented on CALCITE-883: - As far as I see, I am afraid that your proposal may can not 

[jira] [Commented] (CALCITE-883) Support RESPECT NULLS, IGNORE NULLS option for LEAD, LAG, FIRST_VALUE, LAST_VALUE window functions

[ https://issues.apache.org/jira/browse/CALCITE-883?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16799540#comment-16799540 ] Chunwei Lei commented on CALCITE-883: - [~zhztheplayer] Thank you for your patient explanation. It

[jira] [Updated] (CALCITE-883) Support RESPECT NULLS, IGNORE NULLS option for LEAD, LAG, FIRST_VALUE, LAST_VALUE window functions

[ https://issues.apache.org/jira/browse/CALCITE-883?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Chunwei Lei updated CALCITE-883: Attachment: (was: image-2019-03-23-13-03-47-184.png) > Support RESPECT NULLS, IGNORE NULLS

[jira] [Updated] (CALCITE-883) Support RESPECT NULLS, IGNORE NULLS option for LEAD, LAG, FIRST_VALUE, LAST_VALUE window functions

[ https://issues.apache.org/jira/browse/CALCITE-883?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Chunwei Lei updated CALCITE-883: Attachment: image-2019-03-23-13-03-47-184.png > Support RESPECT NULLS, IGNORE NULLS option for

[jira] [Commented] (CALCITE-883) Support RESPECT NULLS, IGNORE NULLS option for LEAD, LAG, FIRST_VALUE, LAST_VALUE window functions

[ https://issues.apache.org/jira/browse/CALCITE-883?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16800782#comment-16800782 ] Chunwei Lei commented on CALCITE-883: - Please feel free to do it. Furthermore, maybe we can work

[jira] [Commented] (CALCITE-2846) Document Oracle-specific functions, such as NVL and LTRIM, in the SQL reference

[ https://issues.apache.org/jira/browse/CALCITE-2846?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16809475#comment-16809475 ] Chunwei Lei commented on CALCITE-2846: -- [~stutigupta], sure. Please feel free to let me know if I

[jira] [Commented] (CALCITE-2965) Implement string functions: REPEAT, SPACE, SOUNDEX, DIFFERENCE

[ https://issues.apache.org/jira/browse/CALCITE-2965?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16809479#comment-16809479 ] Chunwei Lei commented on CALCITE-2965: -- Agree +1. I would like to take it, but it seems 

[jira] [Assigned] (CALCITE-1338) JoinProjectTransposeRule makes wrong transformation when the right child of left outer join has a RexLiteral project expression.

[ https://issues.apache.org/jira/browse/CALCITE-1338?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Chunwei Lei reassigned CALCITE-1338: Assignee: Chunwei Lei > JoinProjectTransposeRule makes wrong transformation when the

[jira] [Closed] (CALCITE-1515) Support TableFunctionScan in RelBuilder

[ https://issues.apache.org/jira/browse/CALCITE-1515?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Chunwei Lei closed CALCITE-1515. > Support TableFunctionScan in RelBuilder > --- > >

[jira] [Comment Edited] (CALCITE-1515) Support TableFunctionScan in RelBuilder

[ https://issues.apache.org/jira/browse/CALCITE-1515?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16805834#comment-16805834 ] Chunwei Lei edited comment on CALCITE-1515 at 3/30/19 1:51 PM: --- Fixed in 

[jira] [Comment Edited] (CALCITE-1515) Support TableFunctionScan in RelBuilder

[ https://issues.apache.org/jira/browse/CALCITE-1515?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16805834#comment-16805834 ] Chunwei Lei edited comment on CALCITE-1515 at 3/30/19 1:52 PM: --- Fixed in 

[jira] [Resolved] (CALCITE-1515) Support TableFunctionScan in RelBuilder

[ https://issues.apache.org/jira/browse/CALCITE-1515?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Chunwei Lei resolved CALCITE-1515. -- Resolution: Fixed Fix Version/s: 1.20.0 Fixed in 

[jira] [Updated] (CALCITE-1515) Support TableFunctionScan in RelBuilder

[ https://issues.apache.org/jira/browse/CALCITE-1515?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Chunwei Lei updated CALCITE-1515: - Affects Version/s: (was: 1.10.0) 1.19.0 > Support TableFunctionScan

[jira] [Commented] (CALCITE-1515) Support TableFunctionScan in RelBuilder

[ https://issues.apache.org/jira/browse/CALCITE-1515?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16804513#comment-16804513 ] Chunwei Lei commented on CALCITE-1515: -- [~julianhyde] +1, thank you for your review and fix-up. >

[jira] [Commented] (CALCITE-883) Support RESPECT NULLS, IGNORE NULLS option for LEAD, LAG, FIRST_VALUE, LAST_VALUE window functions

[ https://issues.apache.org/jira/browse/CALCITE-883?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16804743#comment-16804743 ] Chunwei Lei commented on CALCITE-883: - [~julianhyde], I agree with the idea of [~zhztheplayer] after

[jira] [Comment Edited] (CALCITE-883) Support RESPECT NULLS, IGNORE NULLS option for LEAD, LAG, FIRST_VALUE, LAST_VALUE window functions

[ https://issues.apache.org/jira/browse/CALCITE-883?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16804743#comment-16804743 ] Chunwei Lei edited comment on CALCITE-883 at 3/29/19 9:34 AM: --

[jira] [Comment Edited] (CALCITE-883) Support RESPECT NULLS, IGNORE NULLS option for LEAD, LAG, FIRST_VALUE, LAST_VALUE window functions

[ https://issues.apache.org/jira/browse/CALCITE-883?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16804743#comment-16804743 ] Chunwei Lei edited comment on CALCITE-883 at 3/29/19 9:37 AM: --

[jira] [Commented] (CALCITE-2658) Introducing more ReduceExpressionRules

[ https://issues.apache.org/jira/browse/CALCITE-2658?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16803559#comment-16803559 ] Chunwei Lei commented on CALCITE-2658: -- [~zabetak] Thank you for your kindly reply. I have sent an

[jira] [Commented] (CALCITE-2965) Implement string functions: REPEAT, SPACE, SOUNDEX, DIFFERENCE

[ https://issues.apache.org/jira/browse/CALCITE-2965?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16806852#comment-16806852 ] Chunwei Lei commented on CALCITE-2965: -- Ok. It makes sense. > Implement string functions: REPEAT,

[jira] [Commented] (CALCITE-1338) JoinProjectTransposeRule makes wrong transformation when the right child of left outer join has a RexLiteral project expression.

[ https://issues.apache.org/jira/browse/CALCITE-1338?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16812531#comment-16812531 ] Chunwei Lei commented on CALCITE-1338: -- To resolve this, I would like to proposal: * add a new

[jira] [Comment Edited] (CALCITE-1338) JoinProjectTransposeRule makes wrong transformation when the right child of left outer join has a RexLiteral project expression.

[ https://issues.apache.org/jira/browse/CALCITE-1338?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16812531#comment-16812531 ] Chunwei Lei edited comment on CALCITE-1338 at 4/8/19 3:54 PM: -- To resolve

[jira] [Created] (CALCITE-2875) Some misspellings in RelOptListener

Chunwei Lei created CALCITE-2875: Summary: Some misspellings in RelOptListener Key: CALCITE-2875 URL: https://issues.apache.org/jira/browse/CALCITE-2875 Project: Calcite Issue Type: Bug

[jira] [Updated] (CALCITE-2875) Some misspellings in RelOptListener

[ https://issues.apache.org/jira/browse/CALCITE-2875?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Chunwei Lei updated CALCITE-2875: - Description: There are some misspellings in RelOptListener: /** * Notifies this listener

[jira] [Commented] (CALCITE-2875) Some misspellings in RelOptListener

[ https://issues.apache.org/jira/browse/CALCITE-2875?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16777629#comment-16777629 ] Chunwei Lei commented on CALCITE-2875: -- I have created a pull

[jira] [Assigned] (CALCITE-2729) Introducing WindowExpressionRules

[ https://issues.apache.org/jira/browse/CALCITE-2729?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Chunwei Lei reassigned CALCITE-2729: Assignee: Julian Hyde > Introducing WindowExpressionRules >

[jira] [Assigned] (CALCITE-2658) Introducing more ReduceExpressionRules

[ https://issues.apache.org/jira/browse/CALCITE-2658?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Chunwei Lei reassigned CALCITE-2658: Assignee: Julian Hyde > Introducing more ReduceExpressionRules >

[jira] [Updated] (CALCITE-2658) Introducing more ReduceExpressionRules

[ https://issues.apache.org/jira/browse/CALCITE-2658?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Chunwei Lei updated CALCITE-2658: - Affects Version/s: (was: 1.17.0) > Introducing more ReduceExpressionRules >

[jira] [Commented] (CALCITE-2895) Some arguments are undocumented in constructor of LogicalAggregate

[ https://issues.apache.org/jira/browse/CALCITE-2895?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16785458#comment-16785458 ] Chunwei Lei commented on CALCITE-2895: -- I have created a pull request:

[jira] [Created] (CALCITE-2895) Some arguments are undocumented in constructor of LogicalAggregate

Chunwei Lei created CALCITE-2895: Summary: Some arguments are undocumented in constructor of LogicalAggregate Key: CALCITE-2895 URL: https://issues.apache.org/jira/browse/CALCITE-2895 Project:

[jira] [Updated] (CALCITE-2896) RelBuilder supports creating TableFunctionScan

[ https://issues.apache.org/jira/browse/CALCITE-2896?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Chunwei Lei updated CALCITE-2896: - Issue Type: Improvement (was: Bug) > RelBuilder supports creating TableFunctionScan >

[jira] [Updated] (CALCITE-2729) Introducing WindowExpressionRules

[ https://issues.apache.org/jira/browse/CALCITE-2729?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Chunwei Lei updated CALCITE-2729: - Affects Version/s: (was: 1.17.0) > Introducing WindowExpressionRules >

[jira] [Commented] (CALCITE-883) RESPECT NULLS, IGNORE NULLS option for LEAD, LAG window functions

[ https://issues.apache.org/jira/browse/CALCITE-883?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16790247#comment-16790247 ] Chunwei Lei commented on CALCITE-883: - [~seanhychu] Do you plan to finish this? Or else, I would

[jira] [Created] (CALCITE-2908) Add LAST_DAY function

Chunwei Lei created CALCITE-2908: Summary: Add LAST_DAY function Key: CALCITE-2908 URL: https://issues.apache.org/jira/browse/CALCITE-2908 Project: Calcite Issue Type: Bug

[jira] [Commented] (CALCITE-2908) Add LAST_DAY function

[ https://issues.apache.org/jira/browse/CALCITE-2908?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16789235#comment-16789235 ] Chunwei Lei commented on CALCITE-2908: -- I opened a PR:

[jira] [Comment Edited] (CALCITE-1515) Support TableFunctionScan in RelBuilder

[ https://issues.apache.org/jira/browse/CALCITE-1515?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16789516#comment-16789516 ] Chunwei Lei edited comment on CALCITE-1515 at 3/11/19 12:55 PM: Hi

[jira] [Commented] (CALCITE-1515) Support TableFunctionScan in RelBuilder

[ https://issues.apache.org/jira/browse/CALCITE-1515?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16789516#comment-16789516 ] Chunwei Lei commented on CALCITE-1515: -- Hi [~julianhyde] [~anmu] I opened a pull request:

[jira] [Commented] (CALCITE-1515) Support TableFunctionScan in RelBuilder

[ https://issues.apache.org/jira/browse/CALCITE-1515?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16786722#comment-16786722 ] Chunwei Lei commented on CALCITE-1515: -- Hi,[~anmu] It seems that there are a lot of discuss. Do

[jira] [Comment Edited] (CALCITE-2599) Support ASCII(string) in SqlFunctions

[ https://issues.apache.org/jira/browse/CALCITE-2599?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16786713#comment-16786713 ] Chunwei Lei edited comment on CALCITE-2599 at 3/7/19 1:12 PM: -- Hi

[jira] [Commented] (CALCITE-2599) Support ASCII(string) in SqlFunctions

[ https://issues.apache.org/jira/browse/CALCITE-2599?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16786713#comment-16786713 ] Chunwei Lei commented on CALCITE-2599: -- Hi [~winipanda], [~julianhyde] Do you make any progress?

  1   2   3   4   5   6   7   8   9   >