[
https://issues.apache.org/jira/browse/PHOENIX-1664?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
James Taylor updated PHOENIX-1664:
----------------------------------
Description:
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.
was:
Take a look at the typical math functions that are implemented in relational
database systems
(http://www.postgresql.org/docs/current/static/functions-math.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 POWER, LOG, EXP, SQRT, CBRT, etc. 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.
> Implement missing binary string built-in functions
> --------------------------------------------------
>
> Key: PHOENIX-1664
> URL: https://issues.apache.org/jira/browse/PHOENIX-1664
> Project: Phoenix
> Issue Type: Bug
> Reporter: James Taylor
> Labels: gsoc2015
>
> 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.
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
