[
https://issues.apache.org/jira/browse/HIVE-686?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14520935#comment-14520935
]
Alexander Pivovarov commented on HIVE-686:
------------------------------------------
I think this function can be replaced with regexp_extract in many cases, e.g.
{code}
--get dir from path
select regexp_extract('/aaa/bbb/ccc.txt', '(.*)/(.*)', 1);
/aaa/bbb
--get filename from path
select regexp_extract('/aaa/bbb/ccc.txt', '(.*)/(.*)', 2);
ccc.txt
{code}
> add UDF substring_index
> -----------------------
>
> Key: HIVE-686
> URL: https://issues.apache.org/jira/browse/HIVE-686
> Project: Hive
> Issue Type: New Feature
> Components: UDF
> Reporter: Namit Jain
> Assignee: Larry Ogrodnek
> Attachments: HIVE-686.patch, HIVE-686.patch
>
>
> add UDFsubstring_index
> look at
> http://dev.mysql.com/doc/refman/5.0/en/func-op-summary-ref.html
> for details
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
