[ https://issues.apache.org/jira/browse/DRILL-4661?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
jean-claude updated DRILL-4661: ------------------------------- Fix Version/s: 1.7.0 > 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: 1.7.0 > > > 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 (v6.3.4#6332)