[ https://issues.apache.org/jira/browse/PHOENIX-1705?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14352120#comment-14352120 ]
Serhiy Bilousov commented on PHOENIX-1705: ------------------------------------------ [~jamestaylor], Was expectations here to be able to do? {noformat} array_append (array[1,2,3], array [4,5]) => array [1,2,3,4,5] or just array_append (array[1,2,3], 4) {noformat} I also would have better coverage on tests (arrays is always give you problem when you do notexpect it :)) Cases like: 1. AddArrayToArray (null to null (empty to empty) smaller to bigger, bigger to smaller) 2. AddElementToArray (null to null (empty to empty), Element to Null, NullElement to Array) 3. All above with different datatypes (all supported?) Do we expect query like this to work? {noformat} select customerId, array_append(orders, orderid) as orders_list from customers c left join orders o on c.id = o.customerid group by c.customerid; {noformat} to have something like {noformat} customer orders_list 1001 [23,456,23,445] 1002 [678,342] {noformat} Thank you > implement ARRAY_APPEND built in function > ---------------------------------------- > > Key: PHOENIX-1705 > URL: https://issues.apache.org/jira/browse/PHOENIX-1705 > Project: Phoenix > Issue Type: Sub-task > Reporter: Dumindu Buddhika > Assignee: Dumindu Buddhika > Attachments: > PHOENIX-1705_implement_ARRAY_APPEND_built_in_function.patch > > -- This message was sent by Atlassian JIRA (v6.3.4#6332)