[ https://issues.apache.org/jira/browse/HIVE-25230?focusedWorklogId=767075&page=com.atlassian.jira.plugin.system.issuetabpanels:worklog-tabpanel#worklog-767075 ]
ASF GitHub Bot logged work on HIVE-25230: ----------------------------------------- Author: ASF GitHub Bot Created on: 06/May/22 08:21 Start Date: 06/May/22 08:21 Worklog Time Spent: 10m Work Description: stiga-huang commented on PR #2378: URL: https://github.com/apache/hive/pull/2378#issuecomment-1119373397 Thank @dengzhhu653 for taking a look! I just rebased the PR onto the current master branch. Issue Time Tracking ------------------- Worklog Id: (was: 767075) Time Spent: 1.5h (was: 1h 20m) > 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: 1.5h > 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.20.7#820007)