You are viewing a plain text version of this content. The canonical link for it is here.

Posted to dev@phoenix.apache.org by "James Taylor (JIRA)" <ji...@apache.org> on 2016/01/24 04:35:39 UTC

[jira] [Updated] (PHOENIX-1439) LIKE doesn't appear to use skip scanning

     [ https://issues.apache.org/jira/browse/PHOENIX-1439?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

James Taylor updated PHOENIX-1439:
----------------------------------
    Fix Version/s: 4.8.0

> LIKE doesn't appear to use skip scanning
> ----------------------------------------
>
>                 Key: PHOENIX-1439
>                 URL: https://issues.apache.org/jira/browse/PHOENIX-1439
>             Project: Phoenix
>          Issue Type: Improvement
>            Reporter: Brian Johnson
>             Fix For: 4.8.0
>
>
> We had a query using several like statements of the form LIKE 'prefix|%' and LIKE 'prefix2|%' ... and the performance was on par with a full table scan. When we replaced it with BETWEEN 'prefix|' and 'prefix|FFFFFFF...' the query time was substantially faster. It seems that the LIKE query should work with skip scan, but I don't think it's being used.



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)