[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
  Issue Type: Improvement
  Components: core
Affects Versions: 1.35.0
Reporter: jackylau
 Fix For: 1.35.0






--
This message was sent by Atlassian Jira
(v8.20.10#820010)

[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: Improvement
  Components: core
Affects Versions: 1.35.0
Reporter: jackylau
 Fix For: 1.35.0






--
This message was sent by Atlassian Jira
(v8.20.10#820010)

[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: Calcite
  Issue Type: Improvement
  Components: core
Affects Versions: 1.35.0
Reporter: jackylau
 Fix For: 1.35.0






--
This message was sent by Atlassian Jira
(v8.20.10#820010)

[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
  Components: core
Affects Versions: 1.35.0
Reporter: jackylau
 Fix For: 1.35.0






--
This message was sent by Atlassian Jira
(v8.20.10#820010)

[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
  Components: core
Affects Versions: 1.35.0
Reporter: jackylau
 Fix For: 1.35.0






--
This message was sent by Atlassian Jira
(v8.20.10#820010)

[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
  Components: core
Affects Versions: 1.35.0
Reporter: jackylau
 Fix For: 1.35.0






--
This message was sent by Atlassian Jira
(v8.20.10#820010)

[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
  Components: core
Affects Versions: 1.35.0
Reporter: jackylau
 Fix For: 1.35.0






--
This message was sent by Atlassian Jira
(v8.20.10#820010)

[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
  Components: core
Affects Versions: 1.35.0
Reporter: jackylau
 Fix For: 1.35.0


rray_compact(array) - Removes null values from the array.

*Examples:*

 

{{> SELECT array_compact(array(1, 2, 3, null));}}

{{ [1,2,3]}}

{{> SELECT array_compact(array("a", "b", "c"));}}

{{ ["a","b","c"]}}



--
This message was sent by Atlassian Jira
(v8.20.10#820010)

[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: Calcite
  Issue Type: Improvement
  Components: core
Affects Versions: 1.35.0
Reporter: jackylau
 Fix For: 1.35.0






--
This message was sent by Atlassian Jira
(v8.20.10#820010)

[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
  Components: core
Affects Versions: 1.35.0
Reporter: jackylau
 Fix For: 1.35.0






--
This message was sent by Atlassian Jira
(v8.20.10#820010)

[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: Improvement
  Components: core
Affects Versions: 1.34.0
Reporter: jackylau
 Fix For: 1.35.0






--
This message was sent by Atlassian Jira
(v8.20.10#820010)

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

2023-05-17 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
  Components: core
Affects Versions: 1.34.0
Reporter: jackylau
 Fix For: 1.35.0






--
This message was sent by Atlassian Jira
(v8.20.10#820010)

[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
  Issue Type: Improvement
  Components: core
Affects Versions: 1.35.0
Reporter: jackylau
 Fix For: 1.35.0






--
This message was sent by Atlassian Jira
(v8.20.10#820010)

[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: Improvement
  Components: core
Affects Versions: 1.35.0
Reporter: jackylau
 Fix For: 1.35.0


ARRAY_SIZE - Returns the size of an array. 

ARRAY_REPEAT - Returns the array containing element count times.

 

For more details
https://spark.apache.org/docs/latest/api/sql/index.html



--
This message was sent by Atlassian Jira
(v8.20.10#820010)

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

2023-05-10 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: Improvement
  Components: core
Affects Versions: 1.35.0
Reporter: jackylau
 Fix For: 1.35.0


{{MAP_KEYS}} - Returns an unordered array containing the keys of the map. If 
the map itself is null, the function will return null. 

{{MAP_VALUES}} - Returns an unordered array containing the values of the map. 
If the map itself is null, the function will return null. 

For more details
[https://spark.apache.org/docs/latest/sql-ref-functions-builtin.html]



--
This message was sent by Atlassian Jira
(v8.20.10#820010)

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

2023-04-24 Thread jackylau (Jira) 
jackylau created CALCITE-5674:
-

 Summary: cast expr to target type should respect nullable when the 
type is array
 Key: CALCITE-5674
 URL: https://issues.apache.org/jira/browse/CALCITE-5674
 Project: Calcite
  Issue Type: Improvement
Affects Versions: 1.35.0
 Environment: {code:java}
// code placeholder
sql("select cast(array[1,null,2] as int array) from (values (1))")
.columnType("INTEGER NOT NULL ARRAY NOT NULL");

it is not correct, it should return INTEGER ARRAY NOT NULL {code}
Reporter: jackylau
 Fix For: 1.35.0






--
This message was sent by Atlassian Jira
(v8.20.10#820010)

[jira] [Created] (CALCITE-5672) cast type with nullable result it not true

2023-04-23 Thread jackylau (Jira) 
jackylau created CALCITE-5672:
-

 Summary: cast type with nullable result it not true
 Key: CALCITE-5672
 URL: https://issues.apache.org/jira/browse/CALCITE-5672
 Project: Calcite
  Issue Type: Improvement
Affects Versions: 1.34.0
Reporter: jackylau


{code:java}
// code placeholder
sql("select cast(array[1,null,2] as int array) from (values (1))")
.columnType("INTEGER NOT NULL ARRAY NOT NULL"); {code}
it should be INTEGER ARRAY NOT NULL, the nullable constraint is table level, 
the expr's nullable property should not change



--
This message was sent by Atlassian Jira
(v8.20.10#820010)

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

2023-04-18 Thread jackylau (Jira) 
jackylau created CALCITE-5657:
-

 Summary: Add ARRAY_DISTINCT for Spark dialect
 Key: CALCITE-5657
 URL: https://issues.apache.org/jira/browse/CALCITE-5657
 Project: Calcite
  Issue Type: Improvement
  Components: core
Affects Versions: 1.34.0
Reporter: jackylau






--
This message was sent by Atlassian Jira
(v8.20.10#820010)

[jira] [Created] (CALCITE-5539) GREATEST/LEAST/COALESCE OperandTypes is not correct, which should use AT_LEAST_ONE_SAME_VARIADIC like array_concat

2023-02-22 Thread jackylau (Jira) 
jackylau created CALCITE-5539:
-

 Summary: GREATEST/LEAST/COALESCE OperandTypes is not correct, 
which should use AT_LEAST_ONE_SAME_VARIADIC like array_concat
 Key: CALCITE-5539
 URL: https://issues.apache.org/jira/browse/CALCITE-5539
 Project: Calcite
  Issue Type: Bug
  Components: core
Affects Versions: 1.34.0
Reporter: jackylau
 Fix For: 1.34.0






--
This message was sent by Atlassian Jira
(v8.20.10#820010)