[jira] Updated: (HIVE-515) [UDF] new string function INSTR(str,substr)

["Min Zhou (JIRA)" <ji...@apache.org>]

     [ https://issues.apache.org/jira/browse/HIVE-515?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Min Zhou updated HIVE-515:
--------------------------

    Attachment: HIVE-515.patch

patch

> [UDF] new string function INSTR(str,substr)
> -------------------------------------------
>
>                 Key: HIVE-515
>                 URL: https://issues.apache.org/jira/browse/HIVE-515
>             Project: Hadoop Hive
>          Issue Type: Bug
>            Reporter: Min Zhou
>            Assignee: Min Zhou
>         Attachments: HIVE-515.patch
>
>
> UDF for string function INSTR(str,substr)
> This extends the function from MySQL
> http://dev.mysql.com/doc/refman/5.1/en/string-functions.html#function_instr
> usage:
>  INSTR(str, substr)
>  INSTR(str, substr, start)
> example:
> {code:sql}
> select instr('abcd', 'abc') from pokes;  // all result are '1'
> select instr('abcabc', 'ccc') from pokes;  // all result are '0'
> select instr('abcabc', 'abc', 2) from pokes;  // all result are '4'
> {code}

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