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

 INSTR(str, substr)
 INSTR(str, substr, start)

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'

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

View raw message