You are viewing a plain text version of this content. The canonical link for it is here.

Posted to dev@hive.apache.org by "Quanlong Huang (Jira)" <ji...@apache.org> on 2021/06/10 02:29:00 UTC

[jira] [Created] (HIVE-25230) add position and occurrence to instr()

Quanlong Huang created HIVE-25230:
-------------------------------------

             Summary: add position and occurrence to instr()
                 Key: HIVE-25230
                 URL: https://issues.apache.org/jira/browse/HIVE-25230
             Project: Hive
          Issue Type: New Feature
          Components: UDF
            Reporter: Quanlong Huang
            Assignee: Quanlong Huang


Current instr() only supports two arguments:
{code:java}
instr(str, substr) - Returns the index of the first occurance of substr in str
{code}
Other systems (Vertica, Oracle, Impala etc) support additional position and occurrence arguments:
{code:java}
instr(str, substr[, pos[, occurrence]])
{code}
Oracle doc: [https://docs.oracle.com/database/121/SQLRF/functions089.htm#SQLRF00651]

It'd be nice to support this as well. Otherwise, it's a SQL difference between Impala and Hive.
 Impala supports this in IMPALA-3973



--
This message was sent by Atlassian Jira
(v8.3.4#803005)