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 2014/11/12 18:46:34 UTC

[jira] [Resolved] (PHOENIX-1423) Slow query times for tables that were created from existing hbase tables

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

James Taylor resolved PHOENIX-1423.
-----------------------------------
    Resolution: Duplicate

Duplicate of PHOENIX-1439

> 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)