You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@phoenix.apache.org by "James Taylor (JIRA)" <ji...@apache.org> on 2015/02/14 07:30:12 UTC
[jira] [Updated] (PHOENIX-1665) Implement missing ARRAY built-in
functions
[ https://issues.apache.org/jira/browse/PHOENIX-1665?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
James Taylor updated PHOENIX-1665:
----------------------------------
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 ARRAY_APPEND, ARRAY_FILL, ARRAY_PREPEND, etc.
was:
Take a look at the typical binary string functions and bit string operators that are implemented in relational database systems (http://www.postgresql.org/docs/8.1/static/functions-binarystring.html and http://www.postgresql.org/docs/8.1/static/functions-bitstring.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 GET_BYTE, SET_BYTE, GET_BIT, SET_BIT, etc and missing operators include &, |, #, ~, <<, and >>. As a guide, examine how ROUND is implemented in Phoenix as an abstract function with concrete functions per type: long, decimal, and date/time types, as many of the existing built-in functions are already defined but are not applicable for binary types.
> Implement missing ARRAY built-in functions
> -------------------------------------------
>
> Key: PHOENIX-1665
> URL: https://issues.apache.org/jira/browse/PHOENIX-1665
> Project: Phoenix
> Issue Type: Bug
> Reporter: James Taylor
> Labels: gsoc2015
>
> 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 ARRAY_APPEND, ARRAY_FILL, ARRAY_PREPEND, etc.
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)