[jira] Commented: (HIVE-867) Add add UDFs found in mysq

["Zheng Shao (JIRA)" <ji...@apache.org>]

    [ https://issues.apache.org/jira/browse/HIVE-867?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12772907#action_12772907 ] 

Zheng Shao commented on HIVE-867:
---------------------------------

@Edward, sorry for the delay on this.
The most efficient way would be to reuse a private member of type Text, and count the UTF-8 characters for left and right.
For details on UTF-8 char counting, see http://en.wikipedia.org/wiki/UTF-8



> Add add UDFs found in mysq
> --------------------------
>
>                 Key: HIVE-867
>                 URL: https://issues.apache.org/jira/browse/HIVE-867
>             Project: Hadoop Hive
>          Issue Type: New Feature
>            Reporter: Edward Capriolo
>            Assignee: Edward Capriolo
>         Attachments: hive-867-1.diff, hive-867-10.diff, hive-867-2.diff, hive-867-3.diff, hive-867-7.diff
>
>
> Some UDF's that mysql has that hive does not. 
> atan
> aes_decrypt
> aes_encrypt
> bit_and
> bit_count
> bit_length
> bit_or
> bit_xor
> char_length
> char
> character_length
> collation
> compress
> crc32
> encode
> encrypt
> format
> greatest
> in
> inet_oton
> inet_ntoa
> match
> md5
> oct
> ord
> pi
> radians
> sha1 _sha
> sign
> sleep
> truncate

-- 
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.