[
https://issues.apache.org/jira/browse/PHOENIX-1423?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14204868#comment-14204868
]
Taylor Finnell commented on PHOENIX-1423:
-----------------------------------------
Changing the query to be more like
SELECT * from TABLE where rowkey BETWEEN "xyz|" AND "xyz|FFFFFFF...."
Decreases the time to more along what one would expect.
> Slow query times for tables that were created from existing hbase tables
> ------------------------------------------------------------------------
>
> Key: PHOENIX-1423
> URL: https://issues.apache.org/jira/browse/PHOENIX-1423
> Project: Phoenix
> Issue Type: Bug
> Reporter: Taylor Finnell
>
> I used CREATE TABLE to create a table for a table that already existed in
> HBase.
> I then query it using something like
> SELECT * from TABLE where rowkey LIKE "xyz|";
> It takes about 15 seconds to return any records (even if the TABLE is empty)
> However, if I create a table directly in phoenix (a table that does not
> already exist in hbase). The query above takes less than a second.
> Any ideas why this could be?
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
