[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.
