You are viewing a plain text version of this content. The canonical link for it is here.

Posted to dev@phoenix.apache.org by "Powpow Shen (JIRA)" <ji...@apache.org> on 2016/03/17 02:36:33 UTC

[jira] [Commented] (PHOENIX-2777) UPSERT an empty array by sql

    [ 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)