[jira] [Created] (DRILL-5697) Improve performance of filter operator for pattern matching

["Padma Penumarthy (JIRA)" <ji...@apache.org>]

Padma Penumarthy created DRILL-5697:
---------------------------------------

             Summary: Improve performance of filter operator for pattern matching
                 Key: DRILL-5697
                 URL: https://issues.apache.org/jira/browse/DRILL-5697
             Project: Apache Drill
          Issue Type: Improvement
          Components: Execution - Flow
    Affects Versions: 1.11.0
            Reporter: Padma Penumarthy
            Assignee: Padma Penumarthy


Queries using filter with sql like operator use Java regex library for pattern matching. However, for cases like %abc (ends with abc), abc% (starts with abc), %abc% (contains abc), it is observed that implementing these cases with simple code instead of using regex library provides good performance boost (4-6x). Idea is to use special case code for simple, common cases and fall back to Java regex library for complicated ones. That will provide good performance benefit for most common cases.



--
This message was sent by Atlassian JIRA
(v6.4.14#64029)