[PHOENIX-1665] Implement missing ARRAY built-in functions

• Type: Bug
• Status: Resolved
• Priority: Major
• Resolution: Fixed
• Fix Version/s: 4.6.0
• Labels: Java gsoc2015 mentor sql
• Assignee: Dumindu Buddhika
• Reporter: James R. Taylor
• Created: 14/Feb/15 06:28
• Updated: 24/Jan/16 03:00
• Resolved: 24/Jan/16 03:00

Description

Take a look at the typical ARRAY built-in functions that are implemented in relational database systems (http://www.postgresql.org/docs/9.2/static/functions-array.html) and implement the same for Phoenix in Java following this guide: http://phoenix-hbase.blogspot.com/2013/04/how-to-add-your-own-built-in-function.html

Examples of missing functions include UNNEST, ARRAY_APPEND, ARRAY_FILL, ARRAY_PREPEND, etc.

Issue Links

• is a clone of: PHOENIX-1664 Implement missing binary string built-in functions

Sub-Tasks

• Support UNNEST for ARRAY: Closed
• implement ARRAY_APPEND built in function: Closed
• implement ARRAY_PREPEND built in function: Closed
• Document ARRAY_APPEND function in phoenix.csv: Closed
• Implement ARRAY_CAT built in function: Closed
• Change ArraysWithNullsIT to be derived from BaseHBaseManagedTimeIT: Closed
• Implement ARRAY_FILL built in function: Closed
• Implement ARRAY_TO_STRING built in function: Closed
• Implement STRING_TO_ARRAY built in function: Closed
• Document ARRAY_PREPEND, ARRAY_CAT, ARRAY_FILL, ARRAY_TO_STRING functions in phoenix.csv: Closed