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] Created: (HIVE-515) [UDF] new string function INSTR(str,substr)
Date Mon, 25 May 2009 10:47:45 GMT
[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


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