[IMPALA-3973] add position and occurrence to instr()

• Type: New Feature
• Status: Resolved
• Priority: Major
• Resolution: Fixed
• Affects Version/s: Impala 2.2.4
• Fix Version/s: Impala 2.8.0
• Component/s: Backend, Frontend
• Labels: built-in-function documentation ramp-up
• Target Version: Impala 2.8.0
• Assignee: John Russell
• Reporter: Scott Sappenfield
• Created: 11/Aug/16 16:21
• Updated: 04/Jan/17 23:58
• Resolved: 16/Sep/16 13:52

Description

currently instr() is defined as

instr(string str, string substr)

but other systems (Vertica, Oracle, etc) define it as

INSTR ( string , substring [, position [, occurrence ] ] )

Request is to add position and occurrence.

References:

• https://my.vertica.com/docs/7.2.x/HTML/index.htm#Authoring/SQLReferenceManual/Functions/String/INSTR.htm
• http://docs.oracle.com/database/121/SQLRF/functions089.htm#SQLRF00651

See also: https://jira.cloudera.com/browse/CDH-42948

Issue Links

• relates to: IMPALA-4115 Qgen support for instr()