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)