hadoop-hive-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Min Zhou (JIRA)" <j...@apache.org>
Subject [jira] Resolved: (HIVE-515) [UDF] new string function INSTR(str,substr)
Date Thu, 16 Jul 2009 09:00:15 GMT

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

Min Zhou resolved HIVE-515.
---------------------------

    Resolution: Duplicate

duplicates [#HIVE-541]

> [UDF] new string function INSTR(str,substr)
> -------------------------------------------
>
>                 Key: HIVE-515
>                 URL: https://issues.apache.org/jira/browse/HIVE-515
>             Project: Hadoop Hive
>          Issue Type: New Feature
>            Reporter: Min Zhou
>            Assignee: Min Zhou
>         Attachments: HIVE-515-2.patch, 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.


Mime
View raw message