Uploaded image for project: 'IMPALA'
  1. IMPALA
  2. IMPALA-4115

Qgen support for instr()

    XMLWordPrintableJSON

Details

    • New Feature
    • Status: Open
    • Major
    • Resolution: Unresolved
    • Impala 2.8.0
    • None
    • Infrastructure

    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).

      Attachments

        Issue Links

          Activity

            People

              Unassigned Unassigned
              mjacobs Matthew Jacobs
              Votes:
              0 Vote for this issue
              Watchers:
              1 Start watching this issue

              Dates

                Created:
                Updated: