[
https://issues.apache.org/jira/browse/PHOENIX-2777?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15198565#comment-15198565
]
Powpow Shen commented on PHOENIX-2777:
--------------------------------------
Yes, I know empty values/strings in Phoenix are treated as null, so the point
of this feature is about how to create an array with length 0, not 1. Creating
an array by writing "ARRAY['']" in sql will create an array with one null value
in it, which means the length of this array is 1, not 0.
> UPSERT an empty array by sql
> ----------------------------
>
> Key: PHOENIX-2777
> URL: https://issues.apache.org/jira/browse/PHOENIX-2777
> Project: Phoenix
> Issue Type: New Feature
> Reporter: Powpow Shen
>
> ARRAY type field can be inserted by *ARRAY['blah']* which has *ARRAY_LENGTH*
> 1, and it can also accept *NULL*. But it would be great if it can also
> accept *ARRAY[]*, so *ARRAY_LENGTH* can be 0.
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
