[jira] [Comment Edited] (CALCITE-2266) Implement SQL 2016 JSON functions

2018-08-01 Thread Hongze Zhang (JIRA)
[ https://issues.apache.org/jira/browse/CALCITE-2266?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16565239#comment-16565239 ] Hongze Zhang edited comment on CALCITE-2266 at 8/1/18 12:41 PM: Hi 

[jira] [Commented] (CALCITE-2266) Implement SQL 2016 JSON functions

2018-08-01 Thread Hongze Zhang (JIRA)
[ https://issues.apache.org/jira/browse/CALCITE-2266?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16565239#comment-16565239 ] Hongze Zhang commented on CALCITE-2266: --- Hi [~michaelmior], [~suez1224], I have experience in

[jira] [Comment Edited] (CALCITE-2266) Implement SQL 2016 JSON functions

2018-08-09 Thread Hongze Zhang (JIRA)
[ https://issues.apache.org/jira/browse/CALCITE-2266?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16574722#comment-16574722 ] Hongze Zhang edited comment on CALCITE-2266 at 8/9/18 11:57 AM: The

[jira] [Commented] (CALCITE-2266) Implement SQL 2016 JSON functions

2018-08-09 Thread Hongze Zhang (JIRA)
[ https://issues.apache.org/jira/browse/CALCITE-2266?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16574722#comment-16574722 ] Hongze Zhang commented on CALCITE-2266: --- The basic implementation code of this is ready now.

[jira] [Commented] (CALCITE-2266) Implement SQL 2016 JSON functions

2018-08-09 Thread Hongze Zhang (JIRA)
[ https://issues.apache.org/jira/browse/CALCITE-2266?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16575697#comment-16575697 ] Hongze Zhang commented on CALCITE-2266: --- [~michaelmior] Thanks, I have submitted a PR at 

[jira] [Created] (CALCITE-2483) Exception thrown when row number out of int range in Druid segment metadata query.

2018-08-22 Thread Hongze Zhang (JIRA)
Hongze Zhang created CALCITE-2483: - Summary: Exception thrown when row number out of int range in Druid segment metadata query. Key: CALCITE-2483 URL: https://issues.apache.org/jira/browse/CALCITE-2483

[jira] [Updated] (CALCITE-2483) Exception thrown when row number out of int range in Druid segment metadata query.

2018-08-22 Thread Hongze Zhang (JIRA)
[ https://issues.apache.org/jira/browse/CALCITE-2483?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Hongze Zhang updated CALCITE-2483: -- Description: Calcite sends "merge" segment metadata query to Druid to fetch table schema, in

[jira] [Updated] (CALCITE-2483) Druid adapter, when querying Druid segment metadata, throws when row number is larger than Integer.MAX_VALUE

2018-08-23 Thread Hongze Zhang (JIRA)
[ https://issues.apache.org/jira/browse/CALCITE-2483?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Hongze Zhang updated CALCITE-2483: -- Description: Calcite sends "merge" segment metadata query to Druid to fetch table schema, in

[jira] [Commented] (CALCITE-2483) Druid adapter, when querying Druid segment metadata, throws when row number is larger than Integer.MAX_VALUE

2018-08-23 Thread Hongze Zhang (JIRA)
[ https://issues.apache.org/jira/browse/CALCITE-2483?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16591105#comment-16591105 ] Hongze Zhang commented on CALCITE-2483: --- [~julianhyde] Thanks for your reply, I have changed the

[jira] [Commented] (CALCITE-2485) Missing Object-to-String convertion in ElasticsearchEnumerators.convert(Object o, Class clazz)

2018-08-23 Thread Hongze Zhang (JIRA)
[ https://issues.apache.org/jira/browse/CALCITE-2485?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16591140#comment-16591140 ] Hongze Zhang commented on CALCITE-2485: --- [~a.aseev] Thanks!, the fix works for me. But I have

[jira] [Comment Edited] (CALCITE-2483) Druid adapter, when querying Druid segment metadata, throws when row number is larger than Integer.MAX_VALUE

2018-08-25 Thread Hongze Zhang (JIRA)
[ https://issues.apache.org/jira/browse/CALCITE-2483?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16591105#comment-16591105 ] Hongze Zhang edited comment on CALCITE-2483 at 8/25/18 6:59 AM:

[jira] [Created] (CALCITE-2485) Missing Object-to-String convertion in ElasticsearchEnumerators.convert(Object o, Class clazz)

2018-08-23 Thread Hongze Zhang (JIRA)
Hongze Zhang created CALCITE-2485: - Summary: Missing Object-to-String convertion in ElasticsearchEnumerators.convert(Object o, Class clazz) Key: CALCITE-2485 URL:

[jira] [Updated] (CALCITE-2485) Missing Object-to-String convertion in ElasticsearchEnumerators.convert(Object o, Class clazz)

2018-08-23 Thread Hongze Zhang (JIRA)
[ https://issues.apache.org/jira/browse/CALCITE-2485?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Hongze Zhang updated CALCITE-2485: -- Description: SQL text: {code:sql} SELECT a."city_str", b."col" FROM (SELECT

[jira] [Updated] (CALCITE-2485) ES adapter returns wrong result with single projection

2018-08-29 Thread Hongze Zhang (JIRA)
[ https://issues.apache.org/jira/browse/CALCITE-2485?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Hongze Zhang updated CALCITE-2485: -- Summary: ES adapter returns wrong result with single projection (was: Missing

[jira] [Updated] (CALCITE-2485) ES adapter returns wrong result when single projection is used

2018-08-29 Thread Hongze Zhang (JIRA)
[ https://issues.apache.org/jira/browse/CALCITE-2485?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Hongze Zhang updated CALCITE-2485: -- Summary: ES adapter returns wrong result when single projection is used (was: ES adapter

[jira] [Created] (CALCITE-2530) Reasonable behavior of TRIM function when the length of trim character is not 1(one)

2018-09-04 Thread Hongze Zhang (JIRA)
Hongze Zhang created CALCITE-2530: - Summary: Reasonable behavior of TRIM function when the length of trim character is not 1(one) Key: CALCITE-2530 URL: https://issues.apache.org/jira/browse/CALCITE-2530

[jira] [Updated] (CALCITE-2530) Reasonable behavior of TRIM function when the length of trim character is not 1(one)

2018-09-04 Thread Hongze Zhang (JIRA)
[ https://issues.apache.org/jira/browse/CALCITE-2530?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Hongze Zhang updated CALCITE-2530: -- Description: Calcite's TRIM function takes the first character of string to trim the ,

[jira] [Commented] (CALCITE-2530) Reasonable behavior of TRIM function when the length of trim character is not 1(one)

2018-09-04 Thread Hongze Zhang (JIRA)
[ https://issues.apache.org/jira/browse/CALCITE-2530?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16603860#comment-16603860 ] Hongze Zhang commented on CALCITE-2530: --- And found this in SqlOperatorBaseTest#testTrimFunc:  

[jira] [Created] (CALCITE-2535) Runtime failure check not working in SqlTesterImpl.java

2018-09-05 Thread Hongze Zhang (JIRA)
Hongze Zhang created CALCITE-2535: - Summary: Runtime failure check not working in SqlTesterImpl.java Key: CALCITE-2535 URL: https://issues.apache.org/jira/browse/CALCITE-2535 Project: Calcite

[jira] [Comment Edited] (CALCITE-2535) Runtime failure check not working in SqlTesterImpl.java

2018-09-05 Thread Hongze Zhang (JIRA)
[ https://issues.apache.org/jira/browse/CALCITE-2535?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16604765#comment-16604765 ] Hongze Zhang edited comment on CALCITE-2535 at 9/5/18 6:39 PM: ---

[jira] [Commented] (CALCITE-2535) Runtime failure check not working in SqlTesterImpl.java

2018-09-05 Thread Hongze Zhang (JIRA)
[ https://issues.apache.org/jira/browse/CALCITE-2535?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16604765#comment-16604765 ] Hongze Zhang commented on CALCITE-2535: --- [~julianhyde] Thanks for your suggestion. I have

[jira] [Issue Comment Deleted] (CALCITE-2535) Runtime failure check not working in SqlTesterImpl.java

2018-09-05 Thread Hongze Zhang (JIRA)
[ https://issues.apache.org/jira/browse/CALCITE-2535?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Hongze Zhang updated CALCITE-2535: -- Comment: was deleted (was: A possible fix work is at [my

[jira] [Updated] (CALCITE-2530) TRIM function does not throw exception when the length of trim character is not 1(one)

2018-09-05 Thread Hongze Zhang (JIRA)
[ https://issues.apache.org/jira/browse/CALCITE-2530?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Hongze Zhang updated CALCITE-2530: -- Issue Type: Bug (was: Improvement) > TRIM function does not throw exception when the length

[jira] [Updated] (CALCITE-2530) TRIM function does not throw exception when the length of trim character is not 1(one)

2018-09-05 Thread Hongze Zhang (JIRA)
[ https://issues.apache.org/jira/browse/CALCITE-2530?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Hongze Zhang updated CALCITE-2530: -- Summary: TRIM function does not throw exception when the length of trim character is not

[jira] [Comment Edited] (CALCITE-2530) TRIM function does not throw exception when the length of trim character is not 1(one)

2018-09-05 Thread Hongze Zhang (JIRA)
[ https://issues.apache.org/jira/browse/CALCITE-2530?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16604165#comment-16604165 ] Hongze Zhang edited comment on CALCITE-2530 at 9/5/18 9:20 AM: ---

[jira] [Comment Edited] (CALCITE-2530) TRIM function does not throw exception when the length of trim character is not 1(one)

2018-09-05 Thread Hongze Zhang (JIRA)
[ https://issues.apache.org/jira/browse/CALCITE-2530?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16604165#comment-16604165 ] Hongze Zhang edited comment on CALCITE-2530 at 9/5/18 9:23 AM: ---

[jira] [Comment Edited] (CALCITE-2530) TRIM function does not throw exception when the length of trim character is not 1(one)

2018-09-05 Thread Hongze Zhang (JIRA)
[ https://issues.apache.org/jira/browse/CALCITE-2530?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16604165#comment-16604165 ] Hongze Zhang edited comment on CALCITE-2530 at 9/5/18 9:34 AM: ---

[jira] [Created] (CALCITE-2539) Several test case not passed in CalciteSqlOperatorTest.java

2018-09-06 Thread Hongze Zhang (JIRA)
Hongze Zhang created CALCITE-2539: - Summary: Several test case not passed in CalciteSqlOperatorTest.java Key: CALCITE-2539 URL: https://issues.apache.org/jira/browse/CALCITE-2539 Project: Calcite

[jira] [Commented] (CALCITE-2535) Runtime failure check not working in SqlTesterImpl.java

2018-09-06 Thread Hongze Zhang (JIRA)
[ https://issues.apache.org/jira/browse/CALCITE-2535?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16605764#comment-16605764 ] Hongze Zhang commented on CALCITE-2535: --- A PR is submitted at

[jira] [Comment Edited] (CALCITE-2535) Runtime failure check not working in SqlTesterImpl.java

2018-09-06 Thread Hongze Zhang (JIRA)
[ https://issues.apache.org/jira/browse/CALCITE-2535?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16605764#comment-16605764 ] Hongze Zhang edited comment on CALCITE-2535 at 9/6/18 1:26 PM: --- A PR is

[jira] [Comment Edited] (CALCITE-2535) Runtime failure check not working in SqlTesterImpl.java

2018-09-10 Thread Hongze Zhang (JIRA)
[ https://issues.apache.org/jira/browse/CALCITE-2535?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16608877#comment-16608877 ] Hongze Zhang edited comment on CALCITE-2535 at 9/10/18 8:41 AM:

[jira] [Commented] (CALCITE-2535) Runtime failure check not working in SqlTesterImpl.java

2018-09-10 Thread Hongze Zhang (JIRA)
[ https://issues.apache.org/jira/browse/CALCITE-2535?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16608909#comment-16608909 ] Hongze Zhang commented on CALCITE-2535: ---   {quote}Well, if the only issue is

[jira] [Commented] (CALCITE-2535) Runtime failure check not working in SqlTesterImpl.java

2018-09-10 Thread Hongze Zhang (JIRA)
[ https://issues.apache.org/jira/browse/CALCITE-2535?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16608877#comment-16608877 ] Hongze Zhang commented on CALCITE-2535: --- [~vladimirsitnikov] Thanks for your comment:

[jira] [Commented] (CALCITE-2535) Runtime failure check not working in SqlTesterImpl.java

2018-09-10 Thread Hongze Zhang (JIRA)
[ https://issues.apache.org/jira/browse/CALCITE-2535?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16609178#comment-16609178 ] Hongze Zhang commented on CALCITE-2535: --- bq. I meant unwrapping ExceptionInInitializerError in

[jira] [Comment Edited] (CALCITE-2535) Runtime failure check not working in SqlTesterImpl.java

2018-09-10 Thread Hongze Zhang (JIRA)
[ https://issues.apache.org/jira/browse/CALCITE-2535?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16609178#comment-16609178 ] Hongze Zhang edited comment on CALCITE-2535 at 9/10/18 1:25 PM: bq. I

[jira] [Comment Edited] (CALCITE-2535) Runtime failure check not working in SqlTesterImpl.java

2018-09-10 Thread Hongze Zhang (JIRA)
[ https://issues.apache.org/jira/browse/CALCITE-2535?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16609178#comment-16609178 ] Hongze Zhang edited comment on CALCITE-2535 at 9/10/18 1:25 PM: bq. I

[jira] [Commented] (CALCITE-2535) Runtime failure check not working in SqlTesterImpl.java

2018-09-10 Thread Hongze Zhang (JIRA)
[ https://issues.apache.org/jira/browse/CALCITE-2535?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16609492#comment-16609492 ] Hongze Zhang commented on CALCITE-2535: --- [~vladimirsitnikov] Thank you very much for the case,

[jira] [Comment Edited] (CALCITE-2535) Runtime failure check not working in SqlTesterImpl.java

2018-09-10 Thread Hongze Zhang (JIRA)
[ https://issues.apache.org/jira/browse/CALCITE-2535?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16610077#comment-16610077 ] Hongze Zhang edited comment on CALCITE-2535 at 9/11/18 3:37 AM:

[jira] [Comment Edited] (CALCITE-2535) Runtime failure check not working in SqlTesterImpl.java

2018-09-10 Thread Hongze Zhang (JIRA)
[ https://issues.apache.org/jira/browse/CALCITE-2535?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16610077#comment-16610077 ] Hongze Zhang edited comment on CALCITE-2535 at 9/11/18 4:03 AM:

[jira] [Commented] (CALCITE-2535) Runtime failure check not working in SqlTesterImpl.java

2018-09-10 Thread Hongze Zhang (JIRA)
[ https://issues.apache.org/jira/browse/CALCITE-2535?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16610114#comment-16610114 ] Hongze Zhang commented on CALCITE-2535: --- {quote}FNL-3 was to implement exceptions in a runtime

[jira] [Comment Edited] (CALCITE-2530) TRIM function does not throw exception when the length of trim character is not 1(one)

2018-09-05 Thread Hongze Zhang (JIRA)
[ https://issues.apache.org/jira/browse/CALCITE-2530?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16604165#comment-16604165 ] Hongze Zhang edited comment on CALCITE-2530 at 9/5/18 10:27 AM:

[jira] [Commented] (CALCITE-2535) Runtime failure check not working in SqlTesterImpl.java

2018-09-11 Thread Hongze Zhang (JIRA)
[ https://issues.apache.org/jira/browse/CALCITE-2535?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16610214#comment-16610214 ] Hongze Zhang commented on CALCITE-2535: --- [~vladimirsitnikov] {quote}select coalesce(case when

[jira] [Comment Edited] (CALCITE-2535) Runtime failure check not working in SqlTesterImpl.java

2018-09-11 Thread Hongze Zhang (JIRA)
[ https://issues.apache.org/jira/browse/CALCITE-2535?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16610214#comment-16610214 ] Hongze Zhang edited comment on CALCITE-2535 at 9/11/18 7:47 AM:

[jira] [Comment Edited] (CALCITE-2535) Runtime failure check not working in SqlTesterImpl.java

2018-09-11 Thread Hongze Zhang (JIRA)
[ https://issues.apache.org/jira/browse/CALCITE-2535?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16611539#comment-16611539 ] Hongze Zhang edited comment on CALCITE-2535 at 9/12/18 3:45 AM:

[jira] [Commented] (CALCITE-2535) Runtime failure check not working in SqlTesterImpl.java

2018-09-11 Thread Hongze Zhang (JIRA)
[ https://issues.apache.org/jira/browse/CALCITE-2535?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16611539#comment-16611539 ] Hongze Zhang commented on CALCITE-2535: --- [~julianhyde] Thank you very much for the explanation.

[jira] [Comment Edited] (CALCITE-2535) Runtime failure check not working in SqlTesterImpl.java

2018-09-11 Thread Hongze Zhang (JIRA)
[ https://issues.apache.org/jira/browse/CALCITE-2535?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16611539#comment-16611539 ] Hongze Zhang edited comment on CALCITE-2535 at 9/12/18 3:59 AM:

[jira] [Comment Edited] (CALCITE-2535) Runtime failure check not working in SqlTesterImpl.java

2018-09-12 Thread Hongze Zhang (JIRA)
[ https://issues.apache.org/jira/browse/CALCITE-2535?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16611539#comment-16611539 ] Hongze Zhang edited comment on CALCITE-2535 at 9/12/18 7:07 AM:

[jira] [Commented] (CALCITE-525) Exception-handling in built-in functions

2018-10-15 Thread Hongze Zhang (JIRA)
[ https://issues.apache.org/jira/browse/CALCITE-525?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16651127#comment-16651127 ] Hongze Zhang commented on CALCITE-525: -- Hi [~julianhyde] and [~vladimirsitnikov], Thanks for the

[jira] [Comment Edited] (CALCITE-525) Exception-handling in built-in functions

2018-10-16 Thread Hongze Zhang (JIRA)
[ https://issues.apache.org/jira/browse/CALCITE-525?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16651127#comment-16651127 ] Hongze Zhang edited comment on CALCITE-525 at 10/16/18 9:13 AM: Hi

[jira] [Comment Edited] (CALCITE-525) Exception-handling in built-in functions

2018-10-15 Thread Hongze Zhang (JIRA)
[ https://issues.apache.org/jira/browse/CALCITE-525?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16651127#comment-16651127 ] Hongze Zhang edited comment on CALCITE-525 at 10/16/18 5:08 AM: Hi

[jira] [Comment Edited] (CALCITE-525) Exception-handling in built-in functions

2018-10-16 Thread Hongze Zhang (JIRA)
[ https://issues.apache.org/jira/browse/CALCITE-525?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16651127#comment-16651127 ] Hongze Zhang edited comment on CALCITE-525 at 10/16/18 7:27 AM: Hi

[jira] [Comment Edited] (CALCITE-525) Exception-handling in built-in functions

2018-10-16 Thread Hongze Zhang (JIRA)
[ https://issues.apache.org/jira/browse/CALCITE-525?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16651127#comment-16651127 ] Hongze Zhang edited comment on CALCITE-525 at 10/16/18 7:45 AM: Hi

[jira] [Commented] (CALCITE-525) Exception-handling in built-in functions

2018-10-16 Thread Hongze Zhang (JIRA)
[ https://issues.apache.org/jira/browse/CALCITE-525?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16651281#comment-16651281 ] Hongze Zhang commented on CALCITE-525: -- [~vladimirsitnikov] The link is here:

[jira] [Comment Edited] (CALCITE-525) Exception-handling in built-in functions

2018-10-16 Thread Hongze Zhang (JIRA)
[ https://issues.apache.org/jira/browse/CALCITE-525?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16651127#comment-16651127 ] Hongze Zhang edited comment on CALCITE-525 at 10/16/18 9:05 AM: Hi

[jira] [Created] (CALCITE-2648) Implementation of EnumerableWindow does not preserve input collation

2018-10-30 Thread Hongze Zhang (JIRA)
Hongze Zhang created CALCITE-2648: - Summary: Implementation of EnumerableWindow does not preserve input collation Key: CALCITE-2648 URL: https://issues.apache.org/jira/browse/CALCITE-2648 Project:

[jira] [Commented] (CALCITE-2648) Output collation of EnumerableWindow is not consistent with its implementation

2018-10-31 Thread Hongze Zhang (JIRA)
[ https://issues.apache.org/jira/browse/CALCITE-2648?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=1667#comment-1667 ] Hongze Zhang commented on CALCITE-2648: --- Attached PR: https://github.com/apache/calcite/pull/897

[jira] [Commented] (CALCITE-2648) Implementation of EnumerableWindow does not preserve input collation

2018-10-30 Thread Hongze Zhang (JIRA)
[ https://issues.apache.org/jira/browse/CALCITE-2648?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16668690#comment-16668690 ] Hongze Zhang commented on CALCITE-2648: --- [~vlsi] Do you have any plan on fixing this? Thank you

[jira] [Updated] (CALCITE-2648) Output collation of EnumerableWindow is not consistent with its implementation

2018-10-30 Thread Hongze Zhang (JIRA)
[ https://issues.apache.org/jira/browse/CALCITE-2648?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Hongze Zhang updated CALCITE-2648: -- Summary: Output collation of EnumerableWindow is not consistent with its implementation

[jira] [Commented] (CALCITE-2266) Implement SQL 2016 JSON functions

2018-11-02 Thread Hongze Zhang (JIRA)
[ https://issues.apache.org/jira/browse/CALCITE-2266?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16672821#comment-16672821 ] Hongze Zhang commented on CALCITE-2266: --- Hi [~michaelmior], [~julianhyde], [~vlsi], Thank you

[jira] [Comment Edited] (CALCITE-2266) Implement SQL 2016 JSON functions

2018-11-02 Thread Hongze Zhang (JIRA)
[ https://issues.apache.org/jira/browse/CALCITE-2266?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16672821#comment-16672821 ] Hongze Zhang edited comment on CALCITE-2266 at 11/2/18 9:40 AM: Hi

[jira] [Commented] (CALCITE-2224) WITHIN GROUP clause for aggregate functions

2018-11-01 Thread Hongze Zhang (JIRA)
[ https://issues.apache.org/jira/browse/CALCITE-2224?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16672569#comment-16672569 ] Hongze Zhang commented on CALCITE-2224: --- [~julianhyde] Thanks for your suggestions, I have

[jira] [Comment Edited] (CALCITE-2266) Implement SQL 2016 JSON functions

2018-11-06 Thread Hongze Zhang (JIRA)
[ https://issues.apache.org/jira/browse/CALCITE-2266?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16677545#comment-16677545 ] Hongze Zhang edited comment on CALCITE-2266 at 11/7/18 2:15 AM: Hi

[jira] [Commented] (CALCITE-2266) Implement SQL 2016 JSON functions

2018-11-06 Thread Hongze Zhang (JIRA)
[ https://issues.apache.org/jira/browse/CALCITE-2266?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16677545#comment-16677545 ] Hongze Zhang commented on CALCITE-2266: --- Hi [~julianhyde], {quote}Do you still need to up the

[jira] [Commented] (CALCITE-2266) Implement SQL 2016 JSON functions

2018-11-10 Thread Hongze Zhang (JIRA)
[ https://issues.apache.org/jira/browse/CALCITE-2266?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16682530#comment-16682530 ] Hongze Zhang commented on CALCITE-2266: --- [~julianhyde] Thanks for the catch Julian! I have made

[jira] [Commented] (CALCITE-2266) Implement SQL 2016 JSON functions

2018-11-12 Thread Hongze Zhang (JIRA)
[ https://issues.apache.org/jira/browse/CALCITE-2266?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16684653#comment-16684653 ] Hongze Zhang commented on CALCITE-2266: --- [~risdenk] Thank you for fixing up Travis CI, the new

[jira] [Comment Edited] (CALCITE-2670) Combine similar JSON aggregate functions in operator table

2018-11-15 Thread Hongze Zhang (JIRA)
[ https://issues.apache.org/jira/browse/CALCITE-2670?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16688817#comment-16688817 ] Hongze Zhang edited comment on CALCITE-2670 at 11/16/18 12:06 AM: -- bq.

[jira] [Updated] (CALCITE-2670) Combine similar JSON aggregate functions in operator table

2018-11-15 Thread Hongze Zhang (JIRA)
[ https://issues.apache.org/jira/browse/CALCITE-2670?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Hongze Zhang updated CALCITE-2670: -- Description: In current code master of Calcite, operator *JSON_ARRAYAGG* and

[jira] [Commented] (CALCITE-2670) Combine similar JSON aggregate functions in operator table

2018-11-15 Thread Hongze Zhang (JIRA)
[ https://issues.apache.org/jira/browse/CALCITE-2670?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16688817#comment-16688817 ] Hongze Zhang commented on CALCITE-2670: --- bq. Why did you convert some parameters from particular

[jira] [Comment Edited] (CALCITE-2670) Combine similar JSON aggregate functions in operator table

2018-11-15 Thread Hongze Zhang (JIRA)
[ https://issues.apache.org/jira/browse/CALCITE-2670?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16688817#comment-16688817 ] Hongze Zhang edited comment on CALCITE-2670 at 11/16/18 6:58 AM: - bq.

[jira] [Commented] (CALCITE-2266) Implement SQL 2016 JSON functions

2018-11-06 Thread Hongze Zhang (JIRA)
[ https://issues.apache.org/jira/browse/CALCITE-2266?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16676389#comment-16676389 ] Hongze Zhang commented on CALCITE-2266: --- Hi [~vlsi], PR has been updated based on your

[jira] [Commented] (CALCITE-2224) WITHIN GROUP clause for aggregate functions

2018-11-06 Thread Hongze Zhang (JIRA)
[ https://issues.apache.org/jira/browse/CALCITE-2224?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16676757#comment-16676757 ] Hongze Zhang commented on CALCITE-2224: --- [~julianhyde] Thank you very much for your work and for

[jira] [Created] (CALCITE-2670) Combine similar JSON aggregate functions in operator table

2018-11-14 Thread Hongze Zhang (JIRA)
Hongze Zhang created CALCITE-2670: - Summary: Combine similar JSON aggregate functions in operator table Key: CALCITE-2670 URL: https://issues.apache.org/jira/browse/CALCITE-2670 Project: Calcite

[jira] [Commented] (CALCITE-2670) Combine similar JSON aggregate functions in operator table

2018-11-14 Thread Hongze Zhang (JIRA)
[ https://issues.apache.org/jira/browse/CALCITE-2670?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16686412#comment-16686412 ] Hongze Zhang commented on CALCITE-2670: --- A PR attached to

[jira] [Updated] (CALCITE-2670) Combine similar JSON aggregate functions in operator table

2018-11-15 Thread Hongze Zhang (JIRA)
[ https://issues.apache.org/jira/browse/CALCITE-2670?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Hongze Zhang updated CALCITE-2670: -- Description: Improvement contains following: # Combine *JSON_ARRAYAGG_NULL_ON_NULL* and 

[jira] [Updated] (CALCITE-2670) Combine similar JSON aggregate functions in operator table

2018-11-15 Thread Hongze Zhang (JIRA)
[ https://issues.apache.org/jira/browse/CALCITE-2670?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Hongze Zhang updated CALCITE-2670: -- Description: In current code master of Calcite, operator *JSON_ARRAYAGG* and

[jira] [Commented] (CALCITE-525) Exception-handling in built-in functions

2018-10-09 Thread Hongze Zhang (JIRA)
[ https://issues.apache.org/jira/browse/CALCITE-525?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=1661#comment-1661 ] Hongze Zhang commented on CALCITE-525: -- Hi [~julianhyde] and [~vlsi], thank you for the

[jira] [Commented] (CALCITE-525) Exception-handling in built-in functions

2018-10-09 Thread Hongze Zhang (JIRA)
[ https://issues.apache.org/jira/browse/CALCITE-525?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16643086#comment-16643086 ] Hongze Zhang commented on CALCITE-525: -- Hi [~julianhyde], I have filed a

[jira] [Commented] (CALCITE-525) Exception-handling in built-in functions

2018-10-11 Thread Hongze Zhang (JIRA)
[ https://issues.apache.org/jira/browse/CALCITE-525?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16646100#comment-16646100 ] Hongze Zhang commented on CALCITE-525: -- AFAIK, MySQL has [sql

[jira] [Comment Edited] (CALCITE-525) Exception-handling in built-in functions

2018-10-11 Thread Hongze Zhang (JIRA)
[ https://issues.apache.org/jira/browse/CALCITE-525?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16646100#comment-16646100 ] Hongze Zhang edited comment on CALCITE-525 at 10/11/18 8:13 AM: AFAIK,

[jira] [Commented] (CALCITE-525) Exception-handling in built-in functions

2018-10-11 Thread Hongze Zhang (JIRA)
[ https://issues.apache.org/jira/browse/CALCITE-525?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16646160#comment-16646160 ] Hongze Zhang commented on CALCITE-525: -- {quote}Suppose there's SEMI-ANTI-JOIN. Suppose you drop the

[jira] [Commented] (CALCITE-525) Exception-handling in built-in functions

2018-10-11 Thread Hongze Zhang (JIRA)
[ https://issues.apache.org/jira/browse/CALCITE-525?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16646233#comment-16646233 ] Hongze Zhang commented on CALCITE-525: -- Thanks for the example, and I know simply dropping rows

[jira] [Commented] (CALCITE-2535) Runtime failure check not working in SqlTesterImpl.java

2018-09-21 Thread Hongze Zhang (JIRA)
[ https://issues.apache.org/jira/browse/CALCITE-2535?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16623404#comment-16623404 ] Hongze Zhang commented on CALCITE-2535: --- [~julianhyde] Sorry for late reply, and I found an

[jira] [Commented] (CALCITE-2535) Runtime failure check not working in SqlTesterImpl.java

2018-09-21 Thread Hongze Zhang (JIRA)
[ https://issues.apache.org/jira/browse/CALCITE-2535?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16623414#comment-16623414 ] Hongze Zhang commented on CALCITE-2535: --- [~vladimirsitnikov] {quote}I don't quite get the

[jira] [Commented] (CALCITE-2224) WITHIN GROUP clause for aggregate functions

2018-09-25 Thread Hongze Zhang (JIRA)
[ https://issues.apache.org/jira/browse/CALCITE-2224?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16626896#comment-16626896 ] Hongze Zhang commented on CALCITE-2224: --- [~suez1224] I have started a work about resolving

[jira] [Updated] (CALCITE-2593) Failed to plan when aggregate function is like "sum(X + 1) filter (where Y)"

2018-09-25 Thread Hongze Zhang (JIRA)
[ https://issues.apache.org/jira/browse/CALCITE-2593?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Hongze Zhang updated CALCITE-2593: -- Description: Sample SQL: {code:java} select sum(X + 1) filter (where Y) as "SET" from

[jira] [Created] (CALCITE-2593) Failed to plan when SQL is like "sum(X + 1) filter (where Y)"

2018-09-25 Thread Hongze Zhang (JIRA)
Hongze Zhang created CALCITE-2593: - Summary: Failed to plan when SQL is like "sum(X + 1) filter (where Y)" Key: CALCITE-2593 URL: https://issues.apache.org/jira/browse/CALCITE-2593 Project: Calcite

[jira] [Updated] (CALCITE-2593) Failed to plan when aggregate function is like "sum(X + 1) filter (where Y)"

2018-09-25 Thread Hongze Zhang (JIRA)
[ https://issues.apache.org/jira/browse/CALCITE-2593?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Hongze Zhang updated CALCITE-2593: -- Summary: Failed to plan when aggregate function is like "sum(X + 1) filter (where Y)" (was:

[jira] [Updated] (CALCITE-2593) Sometimes failed to plan when aggregate function is like "sum(X + 1) filter (where Y)"

2018-09-26 Thread Hongze Zhang (JIRA)
[ https://issues.apache.org/jira/browse/CALCITE-2593?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Hongze Zhang updated CALCITE-2593: -- Description: Sample SQL: {code:java} select sum(X + 1) filter (where Y) as "SET" from

[jira] [Updated] (CALCITE-2593) Sometimes failed to plan when aggregate function is like "sum(X + 1) filter (where Y)"

2018-09-26 Thread Hongze Zhang (JIRA)
[ https://issues.apache.org/jira/browse/CALCITE-2593?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Hongze Zhang updated CALCITE-2593: -- Description: Sample SQL: {code:java} select sum(X + 1) filter (where Y) as "SET" from

[jira] [Commented] (CALCITE-2224) WITHIN GROUP clause for aggregate functions

2018-09-27 Thread Hongze Zhang (JIRA)
[ https://issues.apache.org/jira/browse/CALCITE-2224?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16630064#comment-16630064 ] Hongze Zhang commented on CALCITE-2224: --- Here is a possible fix:

[jira] [Comment Edited] (CALCITE-2648) Output collation of EnumerableWindow is not consistent with its implementation

2019-01-04 Thread Hongze Zhang (JIRA)
[ https://issues.apache.org/jira/browse/CALCITE-2648?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16734520#comment-16734520 ] Hongze Zhang edited comment on CALCITE-2648 at 1/5/19 1:40 AM: ---

[jira] [Comment Edited] (CALCITE-2593) Sometimes fails to plan when a RelNode transform multiple collations to single collation

2019-01-03 Thread Hongze Zhang (JIRA)
[ https://issues.apache.org/jira/browse/CALCITE-2593?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16732936#comment-16732936 ] Hongze Zhang edited comment on CALCITE-2593 at 1/3/19 11:27 AM:

[jira] [Commented] (CALCITE-2762) Quidem env variable is always false if its name is separated by dot(".")

2019-01-03 Thread Hongze Zhang (JIRA)
[ https://issues.apache.org/jira/browse/CALCITE-2762?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16732857#comment-16732857 ] Hongze Zhang commented on CALCITE-2762: --- CALCITE-2403 upgrades Quidem version to 0.9, which

[jira] [Comment Edited] (CALCITE-2593) Sometimes fails to plan when a RelNode transform multiple collations to single collation

2019-01-03 Thread Hongze Zhang (JIRA)
[ https://issues.apache.org/jira/browse/CALCITE-2593?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16732936#comment-16732936 ] Hongze Zhang edited comment on CALCITE-2593 at 1/3/19 12:11 PM:

[jira] [Comment Edited] (CALCITE-2593) Sometimes fails to plan when a RelNode transform multiple collations to single collation

2019-01-03 Thread Hongze Zhang (JIRA)
[ https://issues.apache.org/jira/browse/CALCITE-2593?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16732936#comment-16732936 ] Hongze Zhang edited comment on CALCITE-2593 at 1/3/19 12:11 PM:

[jira] [Commented] (CALCITE-2762) Quidem env variable is always false if its name is separated by dot(".")

2019-01-03 Thread Hongze Zhang (JIRA)
[ https://issues.apache.org/jira/browse/CALCITE-2762?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16732923#comment-16732923 ] Hongze Zhang commented on CALCITE-2762: --- [~vladimirsitnikov] Thanks, I believe a test case is

[jira] [Commented] (CALCITE-2593) Sometimes fails to plan when a RelNode transform multiple collations to single collation

2019-01-03 Thread Hongze Zhang (JIRA)
[ https://issues.apache.org/jira/browse/CALCITE-2593?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16732936#comment-16732936 ] Hongze Zhang commented on CALCITE-2593: --- {quote}Can you please clarify which line of

[jira] [Comment Edited] (CALCITE-2762) Quidem env variable is always false if its name is separated by dot(".")

2019-01-03 Thread Hongze Zhang (JIRA)
[ https://issues.apache.org/jira/browse/CALCITE-2762?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16732923#comment-16732923 ] Hongze Zhang edited comment on CALCITE-2762 at 1/3/19 12:08 PM:

[jira] [Created] (CALCITE-2762) Quidem env variable is always false if its name is separated by dot(".")

2019-01-03 Thread Hongze Zhang (JIRA)
Hongze Zhang created CALCITE-2762: - Summary: Quidem env variable is always false if its name is separated by dot(".") Key: CALCITE-2762 URL: https://issues.apache.org/jira/browse/CALCITE-2762

[jira] [Commented] (CALCITE-2593) Sometimes fails to plan when a RelNode transform multiple collations to single collation

2019-01-03 Thread Hongze Zhang (JIRA)
[ https://issues.apache.org/jira/browse/CALCITE-2593?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16732941#comment-16732941 ] Hongze Zhang commented on CALCITE-2593: --- bq. In other words, [[0, 1], [1]] means the rel is

  1   2   3   4   5   6   >