[jira] (FLINK-31664) Add ARRAY_INTERSECT supported in SQL & Table API

[ https://issues.apache.org/jira/browse/FLINK-31664 ] jackylau deleted comment on FLINK-31664: -- was (Author: jackylau): [~Sergey Nuyanzin] ok, thanks for your explain. i will contact the author first > Add ARRAY_INTERSECT supported in SQL & Table

[jira] [Commented] (FLINK-31377) BinaryArrayData getArray/getMap should Handle null correctly AssertionError: valueArraySize (-6) should >= 0

[ https://issues.apache.org/jira/browse/FLINK-31377?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17737181#comment-17737181 ] jackylau commented on FLINK-31377: -- hi [~Sergey Nuyanzin] [~twalthr] ，does anyone help review the pr

[jira] [Commented] (FLINK-31691) Add MAP_FROM_ENTRIES supported in SQL & Table API

[ https://issues.apache.org/jira/browse/FLINK-31691?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17737180#comment-17737180 ] jackylau commented on FLINK-31691: -- hi [~Sergey Nuyanzin] if you review this pr

[jira] [Comment Edited] (FLINK-31691) Add MAP_FROM_ENTRIES supported in SQL & Table API

[ https://issues.apache.org/jira/browse/FLINK-31691?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17737109#comment-17737109 ] jackylau edited comment on FLINK-31691 at 6/26/23 11:49 AM: hi [~snuyanzin]

[jira] [Commented] (FLINK-31691) Add MAP_FROM_ENTRIES supported in SQL & Table API

[ https://issues.apache.org/jira/browse/FLINK-31691?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17737109#comment-17737109 ] jackylau commented on FLINK-31691: -- hi [~snuyanzin] do you have time to help review?  > Add

[jira] [Commented] (FLINK-32363) calcite 1.21 supports type coercion but flink don't enable it in validate

[ https://issues.apache.org/jira/browse/FLINK-32363?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17733367#comment-17733367 ] jackylau commented on FLINK-32363: -- [~libenchao] Thanks for your explain > calcite 1.21 supports type

[jira] [Created] (FLINK-32363) calcite 1.21 supports type coercion but flink don't enable it in validate

jackylau created FLINK-32363: Summary: calcite 1.21 supports type coercion but flink don't enable it in validate Key: FLINK-32363 URL: https://issues.apache.org/jira/browse/FLINK-32363 Project: Flink

[jira] [Commented] (FLINK-26945) Add DATE_SUB supported in SQL & Table API

[ https://issues.apache.org/jira/browse/FLINK-26945?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17730507#comment-17730507 ] jackylau commented on FLINK-26945: -- hi [~twalthr] this pr is long time no one to review it? will you

[jira] [Comment Edited] (FLINK-31664) Add ARRAY_INTERSECT supported in SQL & Table API

[ https://issues.apache.org/jira/browse/FLINK-31664?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17729616#comment-17729616 ] jackylau edited comment on FLINK-31664 at 6/6/23 7:01 AM: -- [~Sergey Nuyanzin]

[jira] [Commented] (FLINK-31664) Add ARRAY_INTERSECT supported in SQL & Table API

[ https://issues.apache.org/jira/browse/FLINK-31664?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17729616#comment-17729616 ] jackylau commented on FLINK-31664: -- [~Sergey Nuyanzin] ok, thanks for your explain > Add

[jira] [Commented] (FLINK-31664) Add ARRAY_INTERSECT supported in SQL & Table API

[ https://issues.apache.org/jira/browse/FLINK-31664?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17729606#comment-17729606 ] jackylau commented on FLINK-31664: -- hi [~Sergey Nuyanzin] thanks for your suggestion 1) this issue i

[jira] [Commented] (FLINK-31902) cast expr to type with not null should throw exception like calcite

[ https://issues.apache.org/jira/browse/FLINK-31902?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17727389#comment-17727389 ] jackylau commented on FLINK-31902: -- i will fix it in calcite first

[jira] [Commented] (FLINK-31908) cast expr to type with not null should not change nullable of expr

[ https://issues.apache.org/jira/browse/FLINK-31908?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17726140#comment-17726140 ] jackylau commented on FLINK-31908: -- i fixed it in calcite, it will fix when upgrade calcite to 1.35 >

[jira] [Commented] (FLINK-31908) cast expr to type with not null should not change nullable of expr

[ https://issues.apache.org/jira/browse/FLINK-31908?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17719236#comment-17719236 ] jackylau commented on FLINK-31908: -- why i found this is here i supports the flink builtin functions

[jira] [Comment Edited] (FLINK-31908) cast expr to type with not null should not change nullable of expr

[ https://issues.apache.org/jira/browse/FLINK-31908?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17719236#comment-17719236 ] jackylau edited comment on FLINK-31908 at 5/4/23 9:40 AM: -- [~jark]  why i

[jira] [Commented] (FLINK-31908) cast expr to type with not null should not change nullable of expr

[ https://issues.apache.org/jira/browse/FLINK-31908?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17716062#comment-17716062 ] jackylau commented on FLINK-31908: -- hi [~jark] i will fix in calcite first here

[jira] [Comment Edited] (FLINK-31908) cast expr to type with not null should not change nullable of expr

[ https://issues.apache.org/jira/browse/FLINK-31908?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17715705#comment-17715705 ] jackylau edited comment on FLINK-31908 at 4/24/23 10:20 AM: hi [~jark] cast

[jira] [Commented] (FLINK-31908) cast expr to type with not null should not change nullable of expr

[ https://issues.apache.org/jira/browse/FLINK-31908?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17715705#comment-17715705 ] jackylau commented on FLINK-31908: -- cast only make type take effective. and nullable should be use

[jira] [Commented] (FLINK-31902) cast expr to type with not null should throw exception like calcite

[ https://issues.apache.org/jira/browse/FLINK-31902?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17715691#comment-17715691 ] jackylau commented on FLINK-31902: -- the standard grammar it here from iso 2016 {code:java} // code

[jira] [Commented] (FLINK-31902) cast expr to type with not null should throw exception like calcite

[ https://issues.apache.org/jira/browse/FLINK-31902?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17715688#comment-17715688 ] jackylau commented on FLINK-31902: -- hi [~jark]  thanks for your response, it is not sql standard. not

[jira] [Commented] (FLINK-31904) fix current serveral flink nullable type handle

[ https://issues.apache.org/jira/browse/FLINK-31904?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17715626#comment-17715626 ] jackylau commented on FLINK-31904: -- hi [~danny0405] [~twalthr] [~snuyanzin] , i create three subtask to

[jira] [Updated] (FLINK-31906) typeof should only return type exclude nullable

[ https://issues.apache.org/jira/browse/FLINK-31906?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] jackylau updated FLINK-31906: - Description: nullable is table level constraint, which can only show by showing schema   pg

[jira] [Created] (FLINK-31908) cast expr to type with not null should not change nullable of expr

jackylau created FLINK-31908: Summary: cast expr to type with not null should not change nullable of expr Key: FLINK-31908 URL: https://issues.apache.org/jira/browse/FLINK-31908 Project: Flink

[jira] [Updated] (FLINK-31906) typeof should only return type exclude nullable

[ https://issues.apache.org/jira/browse/FLINK-31906?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] jackylau updated FLINK-31906: - Description: nullable is table level constraint, which can only show by showing schema   pg

[jira] [Created] (FLINK-31906) typeof should only return type exclude nullable

jackylau created FLINK-31906: Summary: typeof should only return type exclude nullable Key: FLINK-31906 URL: https://issues.apache.org/jira/browse/FLINK-31906 Project: Flink Issue Type:

[jira] [Updated] (FLINK-31904) fix current serveral flink nullable type handle

[ https://issues.apache.org/jira/browse/FLINK-31904?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] jackylau updated FLINK-31904: - Description: (was: 1. https://issues.apache.org/jira/browse/FLINK-31902) > fix current serveral

[jira] [Created] (FLINK-31904) fix current serveral flink nullable type handle

jackylau created FLINK-31904: Summary: fix current serveral flink nullable type handle Key: FLINK-31904 URL: https://issues.apache.org/jira/browse/FLINK-31904 Project: Flink Issue Type:

[jira] [Updated] (FLINK-31904) fix current serveral flink nullable type handle

[ https://issues.apache.org/jira/browse/FLINK-31904?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] jackylau updated FLINK-31904: - Description: 1. https://issues.apache.org/jira/browse/FLINK-31902 > fix current serveral flink nullable

[jira] [Commented] (FLINK-31902) cast expr to type with not null should throw exception like calcite

[ https://issues.apache.org/jira/browse/FLINK-31902?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17715605#comment-17715605 ] jackylau commented on FLINK-31902: -- hi [~danny0405] [~snuyanzin]  please have a look > cast expr to

[jira] [Updated] (FLINK-31902) cast expr to type with not null should throw exception like calcite

[ https://issues.apache.org/jira/browse/FLINK-31902?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] jackylau updated FLINK-31902: - Description: {code:java} // calcite cast type not null, will throw exception expr("cast(x as int

[jira] [Created] (FLINK-31902) cast expr to type with not null should throw exception like calcite

jackylau created FLINK-31902: Summary: cast expr to type with not null should throw exception like calcite Key: FLINK-31902 URL: https://issues.apache.org/jira/browse/FLINK-31902 Project: Flink

[jira] [Commented] (FLINK-31677) Add MAP_ENTRIES supported in SQL & Table API

[ https://issues.apache.org/jira/browse/FLINK-31677?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17714539#comment-17714539 ] jackylau commented on FLINK-31677: -- hi [~Sergey Nuyanzin] do you have time to review it ?   > Add

[jira] [Commented] (FLINK-31682) map_from_arrays should take whether allow duplicate keys and null key into consideration

[ https://issues.apache.org/jira/browse/FLINK-31682?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17714538#comment-17714538 ] jackylau commented on FLINK-31682: -- hi [~Sergey Nuyanzin] , i supported this here

[jira] [Commented] (FLINK-31751) array return type SpecificTypeStrategies.ARRAY and ifThenElse return type is not correct

[ https://issues.apache.org/jira/browse/FLINK-31751?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17712262#comment-17712262 ] jackylau commented on FLINK-31751: -- the inputTypeStrategy/outputTypeStrategy infers function argument

[jira] [Closed] (FLINK-31751) array return type SpecificTypeStrategies.ARRAY and ifThenElse return type is not correct

[ https://issues.apache.org/jira/browse/FLINK-31751?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] jackylau closed FLINK-31751. Resolution: Not A Problem > array return type SpecificTypeStrategies.ARRAY and ifThenElse return type is

[jira] [Commented] (FLINK-31751) array return type SpecificTypeStrategies.ARRAY and ifThenElse return type is not correct

[ https://issues.apache.org/jira/browse/FLINK-31751?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17709612#comment-17709612 ] jackylau commented on FLINK-31751: -- hi [~twalthr] [~jark] what do you think? > array return type

[jira] [Created] (FLINK-31751) array return type SpecificTypeStrategies.ARRAY and ifThenElse return type is not correct

jackylau created FLINK-31751: Summary: array return type SpecificTypeStrategies.ARRAY and ifThenElse return type is not correct Key: FLINK-31751 URL: https://issues.apache.org/jira/browse/FLINK-31751

[jira] [Updated] (FLINK-31691) Add MAP_FROM_ENTRIES supported in SQL & Table API

[ https://issues.apache.org/jira/browse/FLINK-31691?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] jackylau updated FLINK-31691: - Description: map_from_entries(map) - Returns a map created from an arrays of row with two fields. Note

[jira] [Created] (FLINK-31691) Add MAP_FROM_ENTRIES supported in SQL & Table API

jackylau created FLINK-31691: Summary: Add MAP_FROM_ENTRIES supported in SQL & Table API Key: FLINK-31691 URL: https://issues.apache.org/jira/browse/FLINK-31691 Project: Flink Issue Type:

[jira] [Commented] (FLINK-31602) Add ARRAY_POSITION supported in SQL & Table API

[ https://issues.apache.org/jira/browse/FLINK-31602?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17707755#comment-17707755 ] jackylau commented on FLINK-31602: -- Merged to master as

[jira] [Comment Edited] (FLINK-31602) Add ARRAY_POSITION supported in SQL & Table API

[ https://issues.apache.org/jira/browse/FLINK-31602?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17707755#comment-17707755 ] jackylau edited comment on FLINK-31602 at 4/3/23 4:06 AM: -- Merged to master as

[jira] [Closed] (FLINK-31602) Add ARRAY_POSITION supported in SQL & Table API

[ https://issues.apache.org/jira/browse/FLINK-31602?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] jackylau closed FLINK-31602. Resolution: Fixed > Add ARRAY_POSITION supported in SQL & Table API >

[jira] [Updated] (FLINK-31682) map_from_arrays should take whether allow duplicate keys and null key into consideration

[ https://issues.apache.org/jira/browse/FLINK-31682?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] jackylau updated FLINK-31682: - Description: after research the spark/presto/maxcompute about map_from_arrays/map_from_entries, there

[jira] [Created] (FLINK-31682) map_from_arrays should take whether allow duplicate keys and null key into consideration

jackylau created FLINK-31682: Summary: map_from_arrays should take whether allow duplicate keys and null key into consideration Key: FLINK-31682 URL: https://issues.apache.org/jira/browse/FLINK-31682

[jira] [Updated] (FLINK-31677) Add MAP_ENTRIES supported in SQL & Table API

[ https://issues.apache.org/jira/browse/FLINK-31677?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] jackylau updated FLINK-31677: - Description: map_entries(map) - Returns an unordered array of all entries in the given map. Syntax:

[jira] [Created] (FLINK-31677) Add MAP_ENTRIES supported in SQL & Table API

jackylau created FLINK-31677: Summary: Add MAP_ENTRIES supported in SQL & Table API Key: FLINK-31677 URL: https://issues.apache.org/jira/browse/FLINK-31677 Project: Flink Issue Type: Improvement

[jira] [Commented] (FLINK-31663) Add ARRAY_EXCEPT supported in SQL & Table API

[ https://issues.apache.org/jira/browse/FLINK-31663?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17706693#comment-17706693 ] jackylau commented on FLINK-31663: -- should links to https://issues.apache.org/jira/browse/FLINK-22484

[jira] [Updated] (FLINK-31118) Add ARRAY_UNION supported in SQL & Table API

[ https://issues.apache.org/jira/browse/FLINK-31118?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] jackylau updated FLINK-31118: - Description: Remove all elements that equal to element from array. Syntax: array_union(array)

[jira] [Created] (FLINK-31666) Add ARRAY_OVERLAP supported in SQL & Table API

jackylau created FLINK-31666: Summary: Add ARRAY_OVERLAP supported in SQL & Table API Key: FLINK-31666 URL: https://issues.apache.org/jira/browse/FLINK-31666 Project: Flink Issue Type:

[jira] [Created] (FLINK-31665) Add ARRAY_CONCAT supported in SQL & Table API

jackylau created FLINK-31665: Summary: Add ARRAY_CONCAT supported in SQL & Table API Key: FLINK-31665 URL: https://issues.apache.org/jira/browse/FLINK-31665 Project: Flink Issue Type:

[jira] [Created] (FLINK-31664) Add ARRAY_INTERSECT supported in SQL & Table API

jackylau created FLINK-31664: Summary: Add ARRAY_INTERSECT supported in SQL & Table API Key: FLINK-31664 URL: https://issues.apache.org/jira/browse/FLINK-31664 Project: Flink Issue Type:

[jira] [Updated] (FLINK-31602) Add ARRAY_POSITION supported in SQL & Table API

[ https://issues.apache.org/jira/browse/FLINK-31602?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] jackylau updated FLINK-31602: - Description: array_position(array, element) - Returns the (1-based) index of the first element of the

[jira] [Commented] (FLINK-31622) Add ARRAY_APPEND supported in SQL & Table API

[ https://issues.apache.org/jira/browse/FLINK-31622?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17705296#comment-17705296 ] jackylau commented on FLINK-31622: -- [~Sergey Nuyanzin] ok. thanks for your tip > Add ARRAY_APPEND

[jira] [Commented] (FLINK-31621) Add ARRAY_REVERSE supported in SQL & Table API

[ https://issues.apache.org/jira/browse/FLINK-31621?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17705261#comment-17705261 ] jackylau commented on FLINK-31621: -- hi [~Sergey Nuyanzin] , could you please help review it? > Add

[jira] [Updated] (FLINK-31622) Add ARRAY_APPEND supported in SQL & Table API

[ https://issues.apache.org/jira/browse/FLINK-31622?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] jackylau updated FLINK-31622: - Description: array_append(array, element) - Append the element at the end of the array. Syntax:

[jira] [Updated] (FLINK-31622) Add ARRAY_APPEND supported in SQL & Table API

[ https://issues.apache.org/jira/browse/FLINK-31622?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] jackylau updated FLINK-31622: - Description: array_append(array, element) - Append the element at the end of the array. Syntax:

[jira] [Updated] (FLINK-31622) Add ARRAY_APPEND supported in SQL & Table API

[ https://issues.apache.org/jira/browse/FLINK-31622?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] jackylau updated FLINK-31622: - Description: array_append(array, element) - Append the element at the end of the array. Syntax:

[jira] [Created] (FLINK-31622) Add ARRAY_APPEND supported in SQL & Table API

jackylau created FLINK-31622: Summary: Add ARRAY_APPEND supported in SQL & Table API Key: FLINK-31622 URL: https://issues.apache.org/jira/browse/FLINK-31622 Project: Flink Issue Type:

[jira] [Updated] (FLINK-31621) Add ARRAY_REVERSE supported in SQL & Table API

[ https://issues.apache.org/jira/browse/FLINK-31621?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] jackylau updated FLINK-31621: - Description: array_reverse(array) - Returns an array in reverse order. Syntax: array_reverse(array)

[jira] [Updated] (FLINK-31621) Add ARRAY_REVERSE supported in SQL & Table API

[ https://issues.apache.org/jira/browse/FLINK-31621?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] jackylau updated FLINK-31621: - Description: array_reverse(array) - Returns the input {{ARRAY}} with elements in reverse order.

[jira] [Created] (FLINK-31621) Add ARRAY_REVERSE supported in SQL & Table API

jackylau created FLINK-31621: Summary: Add ARRAY_REVERSE supported in SQL & Table API Key: FLINK-31621 URL: https://issues.apache.org/jira/browse/FLINK-31621 Project: Flink Issue Type:

[jira] [Commented] (FLINK-26945) Add DATE_SUB supported in SQL & Table API

[ https://issues.apache.org/jira/browse/FLINK-26945?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17705173#comment-17705173 ] jackylau commented on FLINK-26945: -- hi [~twalthr] ,do you have time to help review it? > Add DATE_SUB

[jira] [Updated] (FLINK-31602) Add ARRAY_POSITION supported in SQL & Table API

[ https://issues.apache.org/jira/browse/FLINK-31602?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] jackylau updated FLINK-31602: - Description: array_position(array, element) - Returns the (1-based) index of the first element of the

[jira] [Created] (FLINK-31602) Add ARRAY_POSITION supported in SQL & Table API

jackylau created FLINK-31602: Summary: Add ARRAY_POSITION supported in SQL & Table API Key: FLINK-31602 URL: https://issues.apache.org/jira/browse/FLINK-31602 Project: Flink Issue Type:

[jira] [Commented] (FLINK-26945) Add DATE_SUB supported in SQL & Table API

[ https://issues.apache.org/jira/browse/FLINK-26945?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17703975#comment-17703975 ] jackylau commented on FLINK-26945: -- hi [~twalthr] , thanks, i know what does the conversionClass means

[jira] [Comment Edited] (FLINK-26945) Add DATE_SUB supported in SQL & Table API

[ https://issues.apache.org/jira/browse/FLINK-26945?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17703653#comment-17703653 ] jackylau edited comment on FLINK-26945 at 3/22/23 1:05 PM: --- and i I have tried 

[jira] [Commented] (FLINK-26945) Add DATE_SUB supported in SQL & Table API

[ https://issues.apache.org/jira/browse/FLINK-26945?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17703653#comment-17703653 ] jackylau commented on FLINK-26945: -- and i I have tried ResolverRule like spark cast to date in advance,

[jira] [Commented] (FLINK-26945) Add DATE_SUB supported in SQL & Table API

[ https://issues.apache.org/jira/browse/FLINK-26945?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17703649#comment-17703649 ] jackylau commented on FLINK-26945: -- I tried what you said, but it also didn't work . it will throws

[jira] [Commented] (FLINK-26945) Add DATE_SUB supported in SQL & Table API

[ https://issues.apache.org/jira/browse/FLINK-26945?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17703636#comment-17703636 ] jackylau commented on FLINK-26945: -- hi [~twalthr] , i want to do cast ahead like spark through rules

[jira] [Closed] (FLINK-31200) Add MAP_VALUES supported in SQL & Table API

[ https://issues.apache.org/jira/browse/FLINK-31200?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] jackylau closed FLINK-31200. Resolution: Duplicate > Add MAP_VALUES supported in SQL & Table API >

[jira] [Comment Edited] (FLINK-26945) Add DATE_SUB supported in SQL & Table API

[ https://issues.apache.org/jira/browse/FLINK-26945?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17700971#comment-17700971 ] jackylau edited comment on FLINK-26945 at 3/16/23 5:34 AM: --- hi [~jark]

[jira] [Comment Edited] (FLINK-26945) Add DATE_SUB supported in SQL & Table API

[ https://issues.apache.org/jira/browse/FLINK-26945?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17700971#comment-17700971 ] jackylau edited comment on FLINK-26945 at 3/16/23 4:34 AM: --- hi [~jark]

[jira] [Commented] (FLINK-26945) Add DATE_SUB supported in SQL & Table API

[ https://issues.apache.org/jira/browse/FLINK-26945?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17700971#comment-17700971 ] jackylau commented on FLINK-26945: -- hi [~jark] [~twalthr] , when i implement the date_sub builtin

[jira] [Updated] (FLINK-31102) Add ARRAY_REMOVE supported in SQL & Table API

[ https://issues.apache.org/jira/browse/FLINK-31102?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] jackylau updated FLINK-31102: - Description: Remove all elements that equal to element from array. Syntax: array_remove(array, needle)

[jira] [Updated] (FLINK-31102) Add ARRAY_REMOVE supported in SQL & Table API

[ https://issues.apache.org/jira/browse/FLINK-31102?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] jackylau updated FLINK-31102: - Description: Remove all elements that equal to element from array. Syntax: array_remove(array, needle)

[jira] [Commented] (FLINK-31102) Add ARRAY_REMOVE supported in SQL & Table API

[ https://issues.apache.org/jira/browse/FLINK-31102?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17699136#comment-17699136 ] jackylau commented on FLINK-31102: -- [~Sergey Nuyanzin] ,thanks for your suggestion and have fixed. and

[jira] [Comment Edited] (FLINK-31102) Add ARRAY_REMOVE supported in SQL & Table API

[ https://issues.apache.org/jira/browse/FLINK-31102?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17698956#comment-17698956 ] jackylau edited comment on FLINK-31102 at 3/10/23 2:48 PM: --- [~Sergey Nuyanzin]

[jira] [Commented] (FLINK-31102) Add ARRAY_REMOVE supported in SQL & Table API

[ https://issues.apache.org/jira/browse/FLINK-31102?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17698956#comment-17698956 ] jackylau commented on FLINK-31102: -- [~jackylau] yeap, it is a misspelling and i have fixed description

[jira] [Updated] (FLINK-31102) Add ARRAY_REMOVE supported in SQL & Table API

[ https://issues.apache.org/jira/browse/FLINK-31102?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] jackylau updated FLINK-31102: - Description: Remove all elements that equal to element from array. Syntax: array_remove(array, needle)

[jira] [Commented] (FLINK-31377) BinaryArrayData getArray/getMap should Handle null correctly AssertionError: valueArraySize (-6) should >= 0

[ https://issues.apache.org/jira/browse/FLINK-31377?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17698812#comment-17698812 ] jackylau commented on FLINK-31377: -- [~Sergey Nuyanzin] but it impacts on table api and python api. and

[jira] [Commented] (FLINK-31377) BinaryArrayData getArray/getMap should Handle null correctly AssertionError: valueArraySize (-6) should >= 0

[ https://issues.apache.org/jira/browse/FLINK-31377?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17698780#comment-17698780 ] jackylau commented on FLINK-31377: -- this https://issues.apache.org/jira/browse/FLINK-27438 just a pure

[jira] [Commented] (FLINK-31377) BinaryArrayData getArray/getMap should Handle null correctly AssertionError: valueArraySize (-6) should >= 0

[ https://issues.apache.org/jira/browse/FLINK-31377?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17698777#comment-17698777 ] jackylau commented on FLINK-31377: -- [~Sergey Nuyanzin] this unit test code can reproduce it 

[jira] [Commented] (FLINK-31377) BinaryArrayData getArray/getMap should Handle null correctly AssertionError: valueArraySize (-6) should >= 0

[ https://issues.apache.org/jira/browse/FLINK-31377?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17698710#comment-17698710 ] jackylau commented on FLINK-31377: -- hi [~snuyanzin] , array_contains have another bug, could you also

[jira] [Commented] (FLINK-31377) BinaryArrayData getArray/getMap should Handle null correctly AssertionError: valueArraySize (-6) should >= 0

[ https://issues.apache.org/jira/browse/FLINK-31377?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17698701#comment-17698701 ] jackylau commented on FLINK-31377: -- hi [~twalthr] , i don't think needle and element type are

[jira] [Updated] (FLINK-31166) array_contains does NOT work when haystack elements are not nullable and needle is nullable

[ https://issues.apache.org/jira/browse/FLINK-31166?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] jackylau updated FLINK-31166: - Summary: array_contains does NOT work when haystack elements are not nullable and needle is nullable

[jira] [Commented] (FLINK-31377) BinaryArrayData getArray/getMap should Handle null correctly AssertionError: valueArraySize (-6) should >= 0

[ https://issues.apache.org/jira/browse/FLINK-31377?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17698364#comment-17698364 ] jackylau commented on FLINK-31377: -- hi [~twalthr] the fix is simple. i guess you accidentally put the

[jira] [Commented] (FLINK-31377) BinaryArrayData getArray/getMap should Handle null correctly AssertionError: valueArraySize (-6) should >= 0

[ https://issues.apache.org/jira/browse/FLINK-31377?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17698352#comment-17698352 ] jackylau commented on FLINK-31377: -- and i find another problem here

[jira] [Updated] (FLINK-31381) UnsupportedOperationException: Unsupported type when convertTypeToSpec: MAP

[ https://issues.apache.org/jira/browse/FLINK-31381?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] jackylau updated FLINK-31381: - Description: when i fix this https://issues.apache.org/jira/browse/FLINK-31377, and find another bug.

[jira] [Created] (FLINK-31381) UnsupportedOperationException: Unsupported type when convertTypeToSpec: MAP

jackylau created FLINK-31381: Summary: UnsupportedOperationException: Unsupported type when convertTypeToSpec: MAP Key: FLINK-31381 URL: https://issues.apache.org/jira/browse/FLINK-31381 Project: Flink

[jira] [Updated] (FLINK-31377) BinaryArrayData getArray/getMap should Handle null correctly AssertionError: valueArraySize (-6) should >= 0

[ https://issues.apache.org/jira/browse/FLINK-31377?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] jackylau updated FLINK-31377: - Description: you can reproduce this error below. and reason is in ARRAY_CONTAINS {code:java} if the

[jira] [Updated] (FLINK-31377) BinaryArrayData getArray/getMap should Handle null correctly AssertionError: valueArraySize (-6) should >= 0

[ https://issues.apache.org/jira/browse/FLINK-31377?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] jackylau updated FLINK-31377: - Description: you can reproduce this error below. and reason is in ARRAY_CONTAINS {code:java} if the

[jira] [Updated] (FLINK-31377) BinaryArrayData getArray/getMap should Handle null correctly AssertionError: valueArraySize (-6) should >= 0

[ https://issues.apache.org/jira/browse/FLINK-31377?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] jackylau updated FLINK-31377: - Description: you can reproduce this error below. and reason is in ARRAY_CONTAINS {code:java} if the

[jira] [Comment Edited] (FLINK-31377) BinaryArrayData getArray/getMap should Handle null correctly AssertionError: valueArraySize (-6) should >= 0

[ https://issues.apache.org/jira/browse/FLINK-31377?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17698318#comment-17698318 ] jackylau edited comment on FLINK-31377 at 3/9/23 11:19 AM: --- hi [~twalthr]

[jira] [Updated] (FLINK-31377) BinaryArrayData getArray/getMap should Handle null correctly AssertionError: valueArraySize (-6) should >= 0

[ https://issues.apache.org/jira/browse/FLINK-31377?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] jackylau updated FLINK-31377: - Description: {code:java} // code placeholder when i use /*elementGetter =

[jira] [Commented] (FLINK-31377) BinaryArrayData getArray/getMap should Handle null correctly AssertionError: valueArraySize (-6) should >= 0

[ https://issues.apache.org/jira/browse/FLINK-31377?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17698318#comment-17698318 ] jackylau commented on FLINK-31377: -- hi [~twalthr] ,this is a bug from array_contains, when i develop

[jira] [Commented] (FLINK-31166) array_contains element type error

[ https://issues.apache.org/jira/browse/FLINK-31166?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17698315#comment-17698315 ] jackylau commented on FLINK-31166: -- have fixed this pr info [~Sergey Nuyanzin] , thanks for your detail

[jira] [Updated] (FLINK-31166) array_contains element type error

[ https://issues.apache.org/jira/browse/FLINK-31166?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] jackylau updated FLINK-31166: - Description: {{ARRAY_CONTAINS}} works ok for the case when both haystack elements and needle are not

[jira] [Commented] (FLINK-31166) array_contains element type error

[ https://issues.apache.org/jira/browse/FLINK-31166?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17698314#comment-17698314 ] jackylau commented on FLINK-31166: -- hi [~Sergey Nuyanzin] thanks for your description. yeap, you are

[jira] [Created] (FLINK-31377) BinaryArrayData getArray/getMap should Handle null correctly AssertionError: valueArraySize (-6) should >= 0

jackylau created FLINK-31377: Summary: BinaryArrayData getArray/getMap should Handle null correctly AssertionError: valueArraySize (-6) should >= 0 Key: FLINK-31377 URL:

[jira] [Commented] (FLINK-26945) Add DATE_SUB supported in SQL & Table API

[ https://issues.apache.org/jira/browse/FLINK-26945?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17697823#comment-17697823 ] jackylau commented on FLINK-26945: -- [~jark] , yeap. data_sub can be completely replaced by minus,

  1   2   3   4   >