[jira] (CALCITE-5772) Add MAP_CONCAT, MAP_FROM_ENTRIES for Spark dialect

2023-06-24 Thread jackylau (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5772 ] jackylau deleted comment on CALCITE-5772: --- was (Author: jackylau): hi [~julianhyde]  do you have time to help review? > Add MAP_CONCAT, MAP_FROM_ENTRIES for Spark dialect > -

[jira] [Commented] (CALCITE-5772) Add MAP_CONCAT, MAP_FROM_ENTRIES for Spark dialect

2023-06-21 Thread jackylau (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5772?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17735608#comment-17735608 ] jackylau commented on CALCITE-5772: --- hi [~julianhyde]  do you have time to help revie

[jira] [Commented] (CALCITE-5744) Add MAP_FROM_ARRAYS, STR_TO_MAP for Spark dialect

2023-06-18 Thread jackylau (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5744?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17733988#comment-17733988 ] jackylau commented on CALCITE-5744: --- hi [~tanclary] [~julianhyde] [~MasseGuillaume] d

[jira] [Commented] (CALCITE-5772) Add MAP_CONCAT, MAP_FROM_ENTRIES for Spark dialect

2023-06-15 Thread jackylau (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5772?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17733003#comment-17733003 ] jackylau commented on CALCITE-5772: --- hi [~julianhyde] do you have time to help review

[jira] [Commented] (CALCITE-5778) Add ARRAY_JOIN, ARRAYS_OVERLAP, ARRAYS_ZIP for Spark dialect

2023-06-14 Thread jackylau (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5778?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17732451#comment-17732451 ] jackylau commented on CALCITE-5778: --- hi [~jiajunbernoulli] [~julianhyde] [~tanclary]

[jira] [Updated] (CALCITE-5778) Add ARRAY_JOIN, ARRAYS_OVERLAP, ARRAYS_ZIP for Spark dialect

2023-06-14 Thread jackylau (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5778?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] jackylau updated CALCITE-5778: -- Description: h3. [array_join|https://spark.apache.org/docs/latest/api/sql/index.html#array_join] ar

[jira] [Updated] (CALCITE-5778) Add ARRAY_JOIN, ARRAYS_OVERLAP, ARRAYS_ZIP for Spark dialect

2023-06-14 Thread jackylau (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5778?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] jackylau updated CALCITE-5778: -- Description: h3. [array_join|https://spark.apache.org/docs/latest/api/sql/index.html#array_join] ar

[jira] [Updated] (CALCITE-5778) Add ARRAY_JOIN, ARRAYS_OVERLAP, ARRAYS_ZIP for Spark dialect

2023-06-14 Thread jackylau (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5778?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] jackylau updated CALCITE-5778: -- Description: h3. [array_join|https://spark.apache.org/docs/latest/api/sql/index.html#array_join] ar

[jira] [Created] (CALCITE-5778) Add ARRAY_JOIN, ARRAYS_OVERLAP, ARRAYS_ZIP for Spark dialect

2023-06-14 Thread jackylau (Jira)
jackylau created CALCITE-5778: - Summary: Add ARRAY_JOIN, ARRAYS_OVERLAP, ARRAYS_ZIP for Spark dialect Key: CALCITE-5778 URL: https://issues.apache.org/jira/browse/CALCITE-5778 Project: Calcite I

[jira] [Assigned] (CALCITE-5778) Add ARRAY_JOIN, ARRAYS_OVERLAP, ARRAYS_ZIP for Spark dialect

2023-06-14 Thread jackylau (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5778?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] jackylau reassigned CALCITE-5778: - Assignee: jackylau > Add ARRAY_JOIN, ARRAYS_OVERLAP, ARRAYS_ZIP for Spark dialect > --

[jira] (CALCITE-5772) Add MAP_CONCAT, MAP_FROM_ENTRIES for Spark dialect

2023-06-12 Thread jackylau (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5772 ] jackylau deleted comment on CALCITE-5772: --- was (Author: jackylau): hi [~julianhyde] would you have time to review this again, i have several pr which do not submit, i worried conflict with th

[jira] [Updated] (CALCITE-5751) Add ARRAY_APPEND, ARRAY_POSITION, ARRAY_REMOVE ARRAY_PREPEND for Spark dialect

2023-06-10 Thread jackylau (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5751?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] jackylau updated CALCITE-5751: -- Description: h3. [array_append|https://spark.apache.org/docs/latest/api/sql/index.html#array_append]

[jira] [Commented] (CALCITE-5772) Add MAP_CONCAT, MAP_FROM_ENTRIES for Spark dialect

2023-06-08 Thread jackylau (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5772?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17730491#comment-17730491 ] jackylau commented on CALCITE-5772: --- hi [~julianhyde] would you have time to review t

[jira] [Comment Edited] (CALCITE-5772) Add MAP_CONCAT, MAP_FROM_ENTRIES for Spark dialect

2023-06-08 Thread jackylau (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5772?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17730483#comment-17730483 ] jackylau edited comment on CALCITE-5772 at 6/8/23 10:05 AM:

[jira] [Comment Edited] (CALCITE-5772) Add MAP_CONCAT, MAP_FROM_ENTRIES for Spark dialect

2023-06-08 Thread jackylau (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5772?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17730483#comment-17730483 ] jackylau edited comment on CALCITE-5772 at 6/8/23 10:04 AM:

[jira] [Updated] (CALCITE-5772) Add MAP_CONCAT, MAP_FROM_ENTRIES for Spark dialect

2023-06-08 Thread jackylau (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5772?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] jackylau updated CALCITE-5772: -- Description: h3. [map_concat|https://spark.apache.org/docs/latest/api/sql/index.html#map_concat] ma

[jira] [Commented] (CALCITE-5772) Add MAP_CONCAT, MAP_FROM_ENTRIES for Spark dialect

2023-06-08 Thread jackylau (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5772?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17730483#comment-17730483 ] jackylau commented on CALCITE-5772: --- [~jiajunbernoulli] [~julianhyde] [~tanclary]  c

[jira] [Assigned] (CALCITE-5772) Add MAP_CONCAT, MAP_FROM_ENTRIES for Spark dialect

2023-06-08 Thread jackylau (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5772?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] jackylau reassigned CALCITE-5772: - Assignee: jackylau > Add MAP_CONCAT, MAP_FROM_ENTRIES for Spark dialect > ---

[jira] [Updated] (CALCITE-5772) Add MAP_CONCAT, MAP_FROM_ENTRIES for Spark dialect

2023-06-08 Thread jackylau (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5772?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] jackylau updated CALCITE-5772: -- Description: h3. [map_concat|https://spark.apache.org/docs/latest/api/sql/index.html#map_concat] ma

[jira] [Updated] (CALCITE-5772) Add MAP_CONCAT, MAP_FROM_ENTRIES for Spark dialect

2023-06-08 Thread jackylau (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5772?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] jackylau updated CALCITE-5772: -- Description: MAP_FROM_ARRAYS (array1, array2) * Returns a map created from an *array1* and *array2.

[jira] [Created] (CALCITE-5772) Add MAP_CONCAT, MAP_FROM_ENTRIES for Spark dialect

2023-06-08 Thread jackylau (Jira)
jackylau created CALCITE-5772: - Summary: Add MAP_CONCAT, MAP_FROM_ENTRIES for Spark dialect Key: CALCITE-5772 URL: https://issues.apache.org/jira/browse/CALCITE-5772 Project: Calcite Issue Type:

[jira] [Updated] (CALCITE-5772) Add MAP_CONCAT, MAP_FROM_ENTRIES for Spark dialect

2023-06-08 Thread jackylau (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5772?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] jackylau updated CALCITE-5772: -- Description: MAP_FROM_ARRAYS (array1, array2) * Returns a map created from an *array1* and *array2.

[jira] [Comment Edited] (CALCITE-5707) Add ARRAY_CONTAINS for Spark dialect

2023-06-07 Thread jackylau (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5707?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17730345#comment-17730345 ] jackylau edited comment on CALCITE-5707 at 6/8/23 2:54 AM: --- i

[jira] [Updated] (CALCITE-5707) Add ARRAY_CONTAINS for Spark dialect

2023-06-07 Thread jackylau (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5707?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] jackylau updated CALCITE-5707: -- Description: ARRAY_CONTAINS - Returns true if the array contains the value For more details [https:/

[jira] [Commented] (CALCITE-5707) Add ARRAY_CONTAINS for Spark dialect

2023-06-07 Thread jackylau (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5707?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17730345#comment-17730345 ] jackylau commented on CALCITE-5707: --- i modify the description if issue and pr  {code:

[jira] [Commented] (CALCITE-5707) Add ARRAY_CONTAINS for Spark dialect

2023-06-07 Thread jackylau (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5707?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17730344#comment-17730344 ] jackylau commented on CALCITE-5707: --- [~julianhyde] thanks for your suggestion, yeap w

[jira] [Assigned] (CALCITE-5704) Add ARRAY_EXCEPT, ARRAY_INTERSECT and ARRAY_UNION for Spark dialect

2023-06-06 Thread jackylau (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5704?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] jackylau reassigned CALCITE-5704: - Assignee: jackylau > Add ARRAY_EXCEPT, ARRAY_INTERSECT and ARRAY_UNION for Spark dialect > ---

[jira] [Assigned] (CALCITE-5751) Add ARRAY_APPEND, ARRAY_POSITION, ARRAY_REMOVE ARRAY_PREPEND for Spark dialect

2023-06-06 Thread jackylau (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5751?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] jackylau reassigned CALCITE-5751: - Assignee: jackylau > Add ARRAY_APPEND, ARRAY_POSITION, ARRAY_REMOVE ARRAY_PREPEND for Spark di

[jira] [Commented] (CALCITE-5744) Add MAP_FROM_ARRAYS, STR_TO_MAP for Spark dialect

2023-06-05 Thread jackylau (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5744?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17729545#comment-17729545 ] jackylau commented on CALCITE-5744: --- change the description [~tanclary] ,thanks for y

[jira] [Closed] (CALCITE-5739) Add MAP_FROM_ARRAYS for Spark dialect

2023-06-05 Thread jackylau (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5739?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] jackylau closed CALCITE-5739. - Resolution: Duplicate > Add MAP_FROM_ARRAYS for Spark dialect > - >

[jira] [Commented] (CALCITE-5739) Add MAP_FROM_ARRAYS for Spark dialect

2023-06-05 Thread jackylau (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5739?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17729544#comment-17729544 ] jackylau commented on CALCITE-5739: --- add it to https://issues.apache.org/jira/browse/

[jira] [Updated] (CALCITE-5744) Add MAP_FROM_ARRAYS, STR_TO_MAP for Spark dialect

2023-06-05 Thread jackylau (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5744?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] jackylau updated CALCITE-5744: -- Description: MAP_FROM_ARRAYS (array1, array2) * Returns a map created from an *array1* and *array2.

[jira] [Updated] (CALCITE-5744) Add MAP_FROM_ARRAYS, STR_TO_MAP for Spark dialect

2023-06-05 Thread jackylau (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5744?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] jackylau updated CALCITE-5744: -- Summary: Add MAP_FROM_ARRAYS, STR_TO_MAP for Spark dialect (was: Add STR_TO_MAP for Spark dialect)

[jira] [Created] (CALCITE-5751) Add ARRAY_APPEND, ARRAY_POSITION, ARRAY_REMOVE ARRAY_PREPEND for Spark dialect

2023-06-05 Thread jackylau (Jira)
jackylau created CALCITE-5751: - Summary: Add ARRAY_APPEND, ARRAY_POSITION, ARRAY_REMOVE ARRAY_PREPEND for Spark dialect Key: CALCITE-5751 URL: https://issues.apache.org/jira/browse/CALCITE-5751 Project: C

[jira] [Assigned] (CALCITE-5714) Add MAP_ENTRIES for Spark dialect

2023-06-04 Thread jackylau (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5714?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] jackylau reassigned CALCITE-5714: - Assignee: jackylau > Add MAP_ENTRIES for Spark dialect > - > >

[jira] [Commented] (CALCITE-5710) Add ARRAY_MAX and ARRAY_MIN for Spark dialect

2023-06-04 Thread jackylau (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5710?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17729131#comment-17729131 ] jackylau commented on CALCITE-5710: --- thanks [~jiajunxie] [~MasseGuillaume] [~snuyanzi

[jira] [Commented] (CALCITE-5739) Add MAP_FROM_ARRAYS for Spark dialect

2023-06-02 Thread jackylau (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5739?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17728921#comment-17728921 ] jackylau commented on CALCITE-5739: --- and some pr is simple whether it is be merged fa

[jira] [Commented] (CALCITE-5739) Add MAP_FROM_ARRAYS for Spark dialect

2023-06-02 Thread jackylau (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5739?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17728920#comment-17728920 ] jackylau commented on CALCITE-5739: --- [~jiajunbernoulli] thanks for your review, i add

[jira] [Updated] (CALCITE-5744) Add STR_TO_MAP for Spark dialect

2023-06-02 Thread jackylau (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5744?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] jackylau updated CALCITE-5744: -- Description:  STR_TO_MAP(string[, stringDelimiter[, keyValueDelimiter]]) - Returns a map after split

[jira] [Created] (CALCITE-5744) Add STR_TO_MAP for Spark dialect

2023-06-02 Thread jackylau (Jira)
jackylau created CALCITE-5744: - Summary: Add STR_TO_MAP for Spark dialect Key: CALCITE-5744 URL: https://issues.apache.org/jira/browse/CALCITE-5744 Project: Calcite Issue Type: Improvement

[jira] [Updated] (CALCITE-5739) Add MAP_FROM_ARRAYS for Spark dialect

2023-06-01 Thread jackylau (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5739?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] jackylau updated CALCITE-5739: -- Description: MAP_FROM_ARRAYS (array1, array2) * Returns a map created from an *array1* and *array2.

[jira] [Updated] (CALCITE-5739) Add MAP_FROM_ARRAYS for Spark dialect

2023-06-01 Thread jackylau (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5739?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] jackylau updated CALCITE-5739: -- Description: MAP_VALUES(array1, array2) | Returns a map created from an *array1* and *array2. Note th

[jira] [Updated] (CALCITE-5739) Add MAP_FROM_ARRAYS for Spark dialect

2023-06-01 Thread jackylau (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5739?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] jackylau updated CALCITE-5739: -- Description: | s | MAP_VALUES(array1, array2) | Returns a map created from an *array1* and *array2. N

[jira] [Created] (CALCITE-5739) Add MAP_FROM_ARRAYS for Spark dialect

2023-06-01 Thread jackylau (Jira)
jackylau created CALCITE-5739: - Summary: Add MAP_FROM_ARRAYS for Spark dialect Key: CALCITE-5739 URL: https://issues.apache.org/jira/browse/CALCITE-5739 Project: Calcite Issue Type: Improvement

[jira] [Assigned] (CALCITE-5738) Add SORT_ARRAY for Spark dialect

2023-05-31 Thread jackylau (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5738?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] jackylau reassigned CALCITE-5738: - Assignee: jackylau > Add SORT_ARRAY for Spark dialect > > >

[jira] [Updated] (CALCITE-5738) Add SORT_ARRAY for Spark dialect

2023-05-31 Thread jackylau (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5738?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] jackylau updated CALCITE-5738: -- Description: h3. [sort_array|https://spark.apache.org/docs/latest/api/sql/index.html#sort_array] so

[jira] [Updated] (CALCITE-5738) Add SORT_ARRAY for Spark dialect

2023-05-31 Thread jackylau (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5738?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] jackylau updated CALCITE-5738: -- Description: h3. [sort_array|https://spark.apache.org/docs/latest/api/sql/index.html#sort_array] so

[jira] [Created] (CALCITE-5738) Add SORT_ARRAY for Spark dialect

2023-05-31 Thread jackylau (Jira)
jackylau created CALCITE-5738: - Summary: Add SORT_ARRAY for Spark dialect Key: CALCITE-5738 URL: https://issues.apache.org/jira/browse/CALCITE-5738 Project: Calcite Issue Type: Improvement

[jira] [Assigned] (CALCITE-5736) Add ARRAY_REVERSE for Spark dialect

2023-05-30 Thread jackylau (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5736?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] jackylau reassigned CALCITE-5736: - Assignee: jackylau > Add ARRAY_REVERSE for Spark dialect > ---

[jira] [Commented] (CALCITE-5736) Add ARRAY_REVERSE for Spark dialect

2023-05-30 Thread jackylau (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5736?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17727754#comment-17727754 ] jackylau commented on CALCITE-5736: --- spark doesn't support the array_reverse. it sup

[jira] [Closed] (CALCITE-5736) Add ARRAY_REVERSE for Spark dialect

2023-05-30 Thread jackylau (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5736?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] jackylau closed CALCITE-5736. - Resolution: Won't Fix > Add ARRAY_REVERSE for Spark dialect > --- > >

[jira] [Created] (CALCITE-5736) Add ARRAY_REVERSE for Spark dialect

2023-05-30 Thread jackylau (Jira)
jackylau created CALCITE-5736: - Summary: Add ARRAY_REVERSE for Spark dialect Key: CALCITE-5736 URL: https://issues.apache.org/jira/browse/CALCITE-5736 Project: Calcite Issue Type: Improvement

[jira] [Updated] (CALCITE-5734) Add ARRAY_COMPACT for Spark dialect

2023-05-30 Thread jackylau (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5734?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] jackylau updated CALCITE-5734: -- Description: array_compact(array) - Removes null values from the array. *Examples:*   {{> SELECT a

[jira] [Created] (CALCITE-5734) Add ARRAY_COMPACT for Spark dialect

2023-05-30 Thread jackylau (Jira)
jackylau created CALCITE-5734: - Summary: Add ARRAY_COMPACT for Spark dialect Key: CALCITE-5734 URL: https://issues.apache.org/jira/browse/CALCITE-5734 Project: Calcite Issue Type: Improvement

[jira] [Comment Edited] (CALCITE-5731) cast to row type should throw exception when contains null/not null constraint

2023-05-30 Thread jackylau (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5731?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17727480#comment-17727480 ] jackylau edited comment on CALCITE-5731 at 5/30/23 10:53 AM:

[jira] [Commented] (CALCITE-5731) cast to row type should throw exception when contains null/not null constraint

2023-05-30 Thread jackylau (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5731?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17727480#comment-17727480 ] jackylau commented on CALCITE-5731: --- but it breaks the sql standard, i guess it may b

[jira] [Assigned] (CALCITE-5731) cast to row type should throw exception when contains null/not null constraint

2023-05-30 Thread jackylau (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5731?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] jackylau reassigned CALCITE-5731: - Assignee: jackylau > cast to row type should throw exception when contains null/not null const

[jira] [Comment Edited] (CALCITE-5731) cast to row type should throw exception when contains null/not null constraint

2023-05-30 Thread jackylau (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5731?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17727396#comment-17727396 ] jackylau edited comment on CALCITE-5731 at 5/30/23 8:28 AM:

[jira] [Commented] (CALCITE-5731) cast to row type should throw exception when contains null/not null constraint

2023-05-30 Thread jackylau (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5731?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17727396#comment-17727396 ] jackylau commented on CALCITE-5731: --- hi [~libenchao] [~rubenql]  do you have time to

[jira] [Comment Edited] (CALCITE-5731) cast to row type should throw exception when contains null/not null constraint

2023-05-30 Thread jackylau (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5731?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17727387#comment-17727387 ] jackylau edited comment on CALCITE-5731 at 5/30/23 8:14 AM:

[jira] [Commented] (CALCITE-5731) cast to row type should throw exception when contains null/not null constraint

2023-05-30 Thread jackylau (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5731?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17727387#comment-17727387 ] jackylau commented on CALCITE-5731: --- 1)the issue https://issues.apache.org/jira/brows

[jira] [Updated] (CALCITE-5731) cast to row type should throw exception when contains null/not null constraint

2023-05-30 Thread jackylau (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5731?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] jackylau updated CALCITE-5731: -- Description: the cast standard grammar it here from iso 2016 {code:java} // code placeholder ::= CAS

[jira] [Updated] (CALCITE-5731) cast to row type should throw exception when contains null/not null constraint

2023-05-30 Thread jackylau (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5731?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] jackylau updated CALCITE-5731: -- Description: the cast standard grammar it here from iso 2016 {code} // code placeholder ::= CAST A

[jira] [Created] (CALCITE-5731) cast to row type should throw exception when contains null/not null constraint

2023-05-30 Thread jackylau (Jira)
jackylau created CALCITE-5731: - Summary: cast to row type should throw exception when contains null/not null constraint Key: CALCITE-5731 URL: https://issues.apache.org/jira/browse/CALCITE-5731 Project: C

[jira] [Comment Edited] (CALCITE-5704) Add ARRAY_EXCEPT, ARRAY_INTERSECT and ARRAY_UNION for Spark dialect

2023-05-29 Thread jackylau (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5704?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17727311#comment-17727311 ] jackylau edited comment on CALCITE-5704 at 5/30/23 3:39 AM:

[jira] [Commented] (CALCITE-5704) Add ARRAY_EXCEPT, ARRAY_INTERSECT and ARRAY_UNION for Spark dialect

2023-05-29 Thread jackylau (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5704?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17727311#comment-17727311 ] jackylau commented on CALCITE-5704: --- hi [~jiajunbernoulli] i response it in the pr.

[jira] [Commented] (CALCITE-5704) Add ARRAY_EXCEPT, ARRAY_INTERSECT and ARRAY_UNION for Spark dialect

2023-05-28 Thread jackylau (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5704?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17726940#comment-17726940 ] jackylau commented on CALCITE-5704: --- [~libenchao] thanks for your response. another w

[jira] [Commented] (CALCITE-5704) Add ARRAY_EXCEPT, ARRAY_INTERSECT and ARRAY_UNION for Spark dialect

2023-05-23 Thread jackylau (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5704?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17725611#comment-17725611 ] jackylau commented on CALCITE-5704: --- sorry to bother you guys, do you have any sugges

[jira] [Commented] (CALCITE-5704) Add ARRAY_EXCEPT, ARRAY_INTERSECT and ARRAY_UNION for Spark dialect

2023-05-21 Thread jackylau (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5704?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17724749#comment-17724749 ] jackylau commented on CALCITE-5704: --- hi [~julianhyde] [~libenchao] [~jiajunbernoulli]

[jira] [Commented] (CALCITE-5710) Add ARRAY_MAX and ARRAY_MIN for Spark dialect

2023-05-20 Thread jackylau (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5710?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17724524#comment-17724524 ] jackylau commented on CALCITE-5710: --- hi [~jiajunbernoulli] will you help review it fi

[jira] [Commented] (CALCITE-5695) Add MAP_KEYS and MAP_VALUES for Spark dialect

2023-05-19 Thread jackylau (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5695?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17724484#comment-17724484 ] jackylau commented on CALCITE-5695: --- [~jiajunbernoulli] thanks your detail review, th

[jira] [Commented] (CALCITE-5714) Add MAP_ENTRIES for Spark dialect

2023-05-19 Thread jackylau (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5714?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17724205#comment-17724205 ] jackylau commented on CALCITE-5714: --- comments: 1. according to this talk, https://is

[jira] [Updated] (CALCITE-5714) Add MAP_ENTRIES for Spark dialect

2023-05-19 Thread jackylau (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5714?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] jackylau updated CALCITE-5714: -- Description: MAP_ENTRIES - Returns an unordered array of all entries in the given map. For more deta

[jira] [Created] (CALCITE-5714) Add MAP_ENTRIES for Spark dialect

2023-05-19 Thread jackylau (Jira)
jackylau created CALCITE-5714: - Summary: Add MAP_ENTRIES for Spark dialect Key: CALCITE-5714 URL: https://issues.apache.org/jira/browse/CALCITE-5714 Project: Calcite Issue Type: Improvement

[jira] [Updated] (CALCITE-5714) Add MAP_ENTRIES for Spark dialect

2023-05-19 Thread jackylau (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5714?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] jackylau updated CALCITE-5714: -- Description: {{ARRAY_DISTINCT}} - Returns the input ARRAY with unique elements. If the array itself

[jira] [Commented] (CALCITE-5710) Add ARRAY_MAX and ARRAY_MIN for Spark dialect

2023-05-18 Thread jackylau (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5710?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17723862#comment-17723862 ] jackylau commented on CALCITE-5710: --- comments: spark docs: array_max Returns the ma

[jira] [Updated] (CALCITE-5710) Add ARRAY_MAX and ARRAY_MIN for Spark dialect

2023-05-18 Thread jackylau (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5710?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] jackylau updated CALCITE-5710: -- Description: ARRAY_MAX - Returns the maximum value in the array ARRAY_MIN - Returns the minmum value

[jira] [Created] (CALCITE-5710) Add ARRAY_MAX and ARRAY_MIN for Spark dialect

2023-05-18 Thread jackylau (Jira)
jackylau created CALCITE-5710: - Summary: Add ARRAY_MAX and ARRAY_MIN for Spark dialect Key: CALCITE-5710 URL: https://issues.apache.org/jira/browse/CALCITE-5710 Project: Calcite Issue Type: Impro

[jira] [Commented] (CALCITE-5700) Add ARRAY_SIZE and ARRAY_REPEAT for Spark dialect

2023-05-17 Thread jackylau (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5700?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17723764#comment-17723764 ] jackylau commented on CALCITE-5700: --- hi [~julianhyde]  thank you for the reminder. an

[jira] [Updated] (CALCITE-5707) Add ARRAY_CONTAINS for Spark dialect

2023-05-17 Thread jackylau (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5707?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] jackylau updated CALCITE-5707: -- Description: ARRAY_CONTAINS - Returns true if the array contains the value For more details [https:/

[jira] [Updated] (CALCITE-5707) Add ARRAY_CONTAINS for Spark dialect

2023-05-16 Thread jackylau (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5707?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] jackylau updated CALCITE-5707: -- Description: {{ARRAY_DISTINCT}} - Returns true if the array contains the value For more details [htt

[jira] [Assigned] (CALCITE-5707) Add ARRAY_CONTAINS for Spark dialect

2023-05-16 Thread jackylau (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5707?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] jackylau reassigned CALCITE-5707: - Assignee: jackylau > Add ARRAY_CONTAINS for Spark dialect > --

[jira] [Created] (CALCITE-5707) Add ARRAY_CONTAINS for Spark dialect

2023-05-16 Thread jackylau (Jira)
jackylau created CALCITE-5707: - Summary: Add ARRAY_CONTAINS for Spark dialect Key: CALCITE-5707 URL: https://issues.apache.org/jira/browse/CALCITE-5707 Project: Calcite Issue Type: Improvement

[jira] [Commented] (CALCITE-5704) Add ARRAY_EXCEPT, ARRAY_INTERSECT and ARRAY_UNION for Spark dialect

2023-05-16 Thread jackylau (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5704?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17723334#comment-17723334 ] jackylau commented on CALCITE-5704: --- [~julianhyde] but i don't find the definitions o

[jira] [Commented] (CALCITE-5657) Add ARRAY_DISTINCT for Spark dialect

2023-05-16 Thread jackylau (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5657?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17723329#comment-17723329 ] jackylau commented on CALCITE-5657: --- [~libenchao] thanks very much > Add ARRAY_DISTI

[jira] [Commented] (CALCITE-5695) Add MAP_KEYS and MAP_VALUES for Spark dialect

2023-05-16 Thread jackylau (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5695?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17723301#comment-17723301 ] jackylau commented on CALCITE-5695: --- hi [~julianhyde] fixed the description of issue

[jira] [Updated] (CALCITE-5695) Add MAP_KEYS and MAP_VALUES for Spark dialect

2023-05-16 Thread jackylau (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5695?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] jackylau updated CALCITE-5695: -- Description: {{MAP_KEYS}} - Returns the keys of the map as an array, the order of the entries is not

[jira] [Updated] (CALCITE-5695) Add MAP_KEYS and MAP_VALUES for Spark dialect

2023-05-16 Thread jackylau (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5695?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] jackylau updated CALCITE-5695: -- Description: {{MAP_KEYS}} - Returns the keys of the map as an array; the order of the entries is not

[jira] [Updated] (CALCITE-5704) Add ARRAY_EXCEPT, ARRAY_INTERSECT and ARRAY_UNION for Spark dialect

2023-05-16 Thread jackylau (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5704?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] jackylau updated CALCITE-5704: -- Description: array_union(array1, array2) - Returns an array of the elements in the union of array1 a

[jira] [Created] (CALCITE-5704) Add ARRAY_EXCEPT, ARRAY_INTERSECT and ARRAY_UNION for Spark dialect

2023-05-16 Thread jackylau (Jira)
jackylau created CALCITE-5704: - Summary: Add ARRAY_EXCEPT, ARRAY_INTERSECT and ARRAY_UNION for Spark dialect Key: CALCITE-5704 URL: https://issues.apache.org/jira/browse/CALCITE-5704 Project: Calcite

[jira] [Commented] (CALCITE-5695) Add MAP_KEYS and MAP_VALUES for Spark dialect

2023-05-14 Thread jackylau (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5695?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17722458#comment-17722458 ] jackylau commented on CALCITE-5695: --- hi [~julianhyde] sorry for late response.    t

[jira] [Created] (CALCITE-5700) Add ARRAY_SIZE and ARRAY_REPEAT for Spark dialect

2023-05-12 Thread jackylau (Jira)
jackylau created CALCITE-5700: - Summary: Add ARRAY_SIZE and ARRAY_REPEAT for Spark dialect Key: CALCITE-5700 URL: https://issues.apache.org/jira/browse/CALCITE-5700 Project: Calcite Issue Type: I

[jira] [Comment Edited] (CALCITE-5657) Add ARRAY_DISTINCT for Spark dialect

2023-05-11 Thread jackylau (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5657?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17721971#comment-17721971 ] jackylau edited comment on CALCITE-5657 at 5/12/23 1:45 AM:

[jira] [Closed] (CALCITE-5657) Add ARRAY_DISTINCT for Spark dialect

2023-05-11 Thread jackylau (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5657?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] jackylau closed CALCITE-5657. - Resolution: Resolved > Add ARRAY_DISTINCT for Spark dialect > > >

[jira] [Commented] (CALCITE-5657) Add ARRAY_DISTINCT for Spark dialect

2023-05-11 Thread jackylau (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5657?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17721971#comment-17721971 ] jackylau commented on CALCITE-5657: --- https://github.com/apache/calcite/commit/d68656a

[jira] [Created] (CALCITE-5695) Add MAP_KEYS and MAP_VALUES for Spark dialect

2023-05-09 Thread jackylau (Jira)
jackylau created CALCITE-5695: - Summary: Add MAP_KEYS and MAP_VALUES for Spark dialect Key: CALCITE-5695 URL: https://issues.apache.org/jira/browse/CALCITE-5695 Project: Calcite Issue Type: Impro

[jira] [Commented] (CALCITE-5674) Cast expr to target type should respect nullable when it is complex type

2023-05-05 Thread jackylau (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5674?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17719836#comment-17719836 ] jackylau commented on CALCITE-5674: --- After dig the code, it should consider other com

[jira] [Updated] (CALCITE-5674) Cast expr to target type should respect nullable when it is complex type

2023-05-05 Thread jackylau (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5674?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] jackylau updated CALCITE-5674: -- Summary: Cast expr to target type should respect nullable when it is complex type (was: Cast expr to

[jira] [Commented] (CALCITE-5674) Cast expr to target type should respect nullable when the type is array

2023-05-04 Thread jackylau (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5674?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17719613#comment-17719613 ] jackylau commented on CALCITE-5674: --- [~libenchao] thanks, i will submit a pr to fix i

[jira] [Comment Edited] (CALCITE-5674) Cast expr to target type should respect nullable when the type is array

2023-05-04 Thread jackylau (Jira)
[ https://issues.apache.org/jira/browse/CALCITE-5674?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17719234#comment-17719234 ] jackylau edited comment on CALCITE-5674 at 5/4/23 9:38 AM: --- w

  1   2   >