Uploaded image for project: 'Apache HAWQ'
  1. Apache HAWQ
  2. HAWQ-1110

Optimize LIKE operator on storage layer

    XMLWordPrintableJSON

Details

    • Improvement
    • Status: Open
    • Major
    • Resolution: Unresolved
    • None
    • backlog
    • PXF
    • None

    Description

      As for now HiveORC profile doesn't use any storage layer optimizations for LIKE operator.
      Current optimization could be applied:
      1) Parse first token of LIKE clause before first occurrence of "%" symbol.
      2) Apply ORC filter: >=<TOKEN> AND <=<NEXT_TOKEN>

      Where NEXT_TOKEN = <TOKEN>.substring(0, <TOKEN>.length() - 2) + <TOKEN>.substring(<TOKEN>.length() -2, <TOKEN>.length() - 1) + 1

      Attachments

        Activity

          People

            odiachenko Oleksandr Diachenko
            odiachenko Oleksandr Diachenko
            Votes:
            0 Vote for this issue
            Watchers:
            2 Start watching this issue

            Dates

              Created:
              Updated: