You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@flink.apache.org by "Eric Xiao (Jira)" <ji...@apache.org> on 2022/10/26 03:05:00 UTC

[jira] [Comment Edited] (FLINK-20578) Cannot create empty array using ARRAY[]

    [ https://issues.apache.org/jira/browse/FLINK-20578?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17624154#comment-17624154 ] 

Eric Xiao edited comment on FLINK-20578 at 10/26/22 3:04 AM:
-------------------------------------------------------------

Hi I wanted to get more involved in contributing to the Flink project and found this starter task - my team is working with the Table / SQL APIs, so I thought this would be a good beginning task to work on :). [~surahman] are you still working on this issue, I noticed it has been a year since your last comment.

> If Flink support empty array, which data type of elements in array should be ? Does it cause new problems.
[~pensz] I tested a similar query in Trino (Presto) and BigQuery and they by default use Integer as the data type. This could be a good default behaviour?

!Screen Shot 2022-10-25 at 10.50.42 PM.png!
!Screen Shot 2022-10-25 at 10.50.47 PM.png! 
!Screen Shot 2022-10-25 at 11.01.06 PM.png! 



was (Author: JIRAUSER295489):
Hi I wanted to get more involved in contributing to the Flink project and found this starter task - my team is working with the Table / SQL APIs, so I thought this would be a good beginning task to work on :). [~surahman] are you still working on this issue, I noticed it has been a year since your last comment.

> If Flink support empty array, which data type of elements in array should be ? Does it cause new problems.
[~pensz] I tested a similar query in Trino (Presto) and BigQuery and they by default use Integer as the data type. This could be a good default behaviour?

!Screen Shot 2022-10-25 at 10.50.42 PM.png!


> Cannot create empty array using ARRAY[]
> ---------------------------------------
>
>                 Key: FLINK-20578
>                 URL: https://issues.apache.org/jira/browse/FLINK-20578
>             Project: Flink
>          Issue Type: Sub-task
>          Components: Table SQL / API
>    Affects Versions: 1.11.2
>            Reporter: Fabian Hueske
>            Priority: Major
>              Labels: starter
>             Fix For: 1.17.0
>
>         Attachments: Screen Shot 2022-10-25 at 10.50.42 PM.png, Screen Shot 2022-10-25 at 10.50.47 PM.png, Screen Shot 2022-10-25 at 11.01.06 PM.png
>
>
> Calling the ARRAY function without an element (`ARRAY[]`) results in an error message.
> Is that the expected behavior?
> How can users create empty arrays?



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