[IMPALA-4115] Qgen support for instr()

• Type: New Feature
• Status: Open
• Priority: Major
• Resolution: Unresolved
• Affects Version/s: Impala 2.8.0
• Component/s: Infrastructure
• Labels: query_generator test
• Target Version: Product Backlog
• Assignee: Unassigned
• Reporter: Matthew Jacobs
• Created: 10/Sep/16 00:38
• Updated: 15/Feb/18 06:41

Description

IMPALA-3973 adds support for the instr() builtin to have a start position and #occurances with instr(), ie. allows searching forwards and backwards (position < 0) some number of matches.

Oracle and some other databases support this: http://docs.oracle.com/database/121/SQLRF/functions089.htm#SQLRF00651

However, the code is pretty tricky and we should get support in the query generator to test this fn against other databases (Oracle in this case).

Issue Links

• is related to: IMPALA-3973 add position and occurrence to instr()