You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@phoenix.apache.org by "Kyle Buzsaki (JIRA)" <ji...@apache.org> on 2014/07/03 01:26:25 UTC

[jira] [Commented] (PHOENIX-1055) Add support for the built-in functions HEX, OCT, and BIN

    [ https://issues.apache.org/jira/browse/PHOENIX-1055?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14050865#comment-14050865 ] 

Kyle Buzsaki commented on PHOENIX-1055:
---------------------------------------

Note that the HEX function here is distinct from the HEX function in the HEX/UNHEX pair of string manipulation functions. This HEX function only operates on numeric input.

> Add support for the built-in functions HEX, OCT, and BIN 
> ---------------------------------------------------------
>
>                 Key: PHOENIX-1055
>                 URL: https://issues.apache.org/jira/browse/PHOENIX-1055
>             Project: Phoenix
>          Issue Type: New Feature
>            Reporter: Kyle Buzsaki
>         Attachments: PHOENIX-1055.patch
>
>
> Add built-in functions to produce hexadecimal, octal, and binary string representations of numeric values.
> Example Function Specification:
> http://dev.mysql.com/doc/refman/5.0/en/string-functions.html#function_hex
> http://dev.mysql.com/doc/refman/5.0/en/string-functions.html#function_oct
> http://dev.mysql.com/doc/refman/5.0/en/string-functions.html#function_bin



--
This message was sent by Atlassian JIRA
(v6.2#6252)