phoenix-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Thomas D'Silva (JIRA)" <j...@apache.org>
Subject [jira] [Updated] (PHOENIX-1439) LIKE doesn't appear to use skip scanning
Date Wed, 16 Jan 2019 01:25:01 GMT

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

Thomas D'Silva updated PHOENIX-1439:
------------------------------------
    Fix Version/s:     (was: 4.15.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
>            Priority: Major
>              Labels: verify
>
> 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
(v7.6.3#76005)

Mime
View raw message