[ https://issues.apache.org/jira/browse/HIVE-25230?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Work on HIVE-25230 started by Quanlong Huang. --------------------------------------------- > 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 > Priority: Major > Labels: pull-request-available > Time Spent: 10m > Remaining Estimate: 0h > > 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)