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)
