You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@hive.apache.org by "Min Zhou (JIRA)" <ji...@apache.org> on 2009/05/25 12:47:45 UTC
[jira] Created: (HIVE-515) [UDF] new string function
INSTR(str,substr)
[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.
[jira] Assigned: (HIVE-515) [UDF] new string function
INSTR(str,substr)
Posted by "Min Zhou (JIRA)" <ji...@apache.org>.
[ 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.
[jira] Updated: (HIVE-515) [UDF] new string function
INSTR(str,substr)
Posted by "Min Zhou (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/HIVE-515?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Min Zhou updated HIVE-515:
--------------------------
Attachment: HIVE-515.patch
patch
> [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.
[jira] Updated: (HIVE-515) [UDF] new string function
INSTR(str,substr)
Posted by "Min Zhou (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/HIVE-515?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Min Zhou updated HIVE-515:
--------------------------
Attachment: HIVE-515-2.patch
deal with null arguments
> [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.
[jira] Resolved: (HIVE-515) [UDF] new string function
INSTR(str,substr)
Posted by "Min Zhou (JIRA)" <ji...@apache.org>.
[ 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.
[jira] Updated: (HIVE-515) [UDF] new string function
INSTR(str,substr)
Posted by "Min Zhou (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/HIVE-515?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Min Zhou updated HIVE-515:
--------------------------
Issue Type: New Feature (was: Bug)
> [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.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.