[
https://issues.apache.org/jira/browse/DRILL-4661?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Kunal Khatua closed DRILL-4661.
-------------------------------
Resolution: Fixed
I think this has been resolved.with DRILL-5899 .
> Optimze the LIKE function
> -------------------------
>
> Key: DRILL-4661
> URL: https://issues.apache.org/jira/browse/DRILL-4661
> Project: Apache Drill
> Issue Type: Improvement
> Reporter: jean-claude
> Priority: Minor
> Fix For: Future
>
>
> The LIKE function is implemented using the java regex. This is different from
> the STRPOS function which compares byte by byte.
> When doing to testing I've noticed that for cases where the user wants to do
> a restriction like WHERE COL1 LIKE '%xyz%' it would be faster to actually do
> WHERE STRPOS(COL1, '%xyz%') > 0
> I propose to change the LIKE operator's algorithm so that it detects if a
> byte by byte compare could be applied and if so use the same technique as the
> STRPOS function. Cases of the form '%xyz%', 'xyz%' and '%xyz' could be
> handled this way.
--
This message was sent by Atlassian JIRA
(v7.6.3#76005)
