You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@phoenix.apache.org by "Dumindu Buddhika (JIRA)" <ji...@apache.org> on 2015/07/06 16:28:04 UTC

[jira] [Created] (PHOENIX-2101) Implement ARRAY_TO_STRING built in function

Dumindu Buddhika created PHOENIX-2101:
-----------------------------------------

             Summary: Implement ARRAY_TO_STRING built in function
                 Key: PHOENIX-2101
                 URL: https://issues.apache.org/jira/browse/PHOENIX-2101
             Project: Phoenix
          Issue Type: Sub-task
            Reporter: Dumindu Buddhika
            Assignee: Dumindu Buddhika


ARRAY_TO_STRING(anyarray, text [, text]) - Concatenates array elements using supplied delimiter and optional null string and returns the resulting string

eg:
ARRAY_TO_STRING(ARRAY['1', '2, '3', NULL, '5'], ',', '*') → '1,2,3,*,5'
ARRAY_TO_STRING(ARRAY[23, 34, 45], ',') → '23,34,45'



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)