[ https://issues.apache.org/jira/browse/HIVE-515?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Min Zhou reassigned HIVE-515: ----------------------------- Assignee: Min Zhou > [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.