phoenix-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "James Taylor (JIRA)" <j...@apache.org>
Subject [jira] [Updated] (PHOENIX-1664) Implement missing binary string built-in functions
Date Sat, 14 Feb 2015 06:28:11 GMT

     [ 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)

Mime
View raw message