You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@phoenix.apache.org by "Lars Hofhansl (JIRA)" <ji...@apache.org> on 2015/02/13 02:54:11 UTC
[jira] [Resolved] (PHOENIX-1292) Some queries that filter all rows
are slow.
[ https://issues.apache.org/jira/browse/PHOENIX-1292?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Lars Hofhansl resolved PHOENIX-1292.
------------------------------------
Resolution: Later
Marking as "Later". We can revisit this when needed.
> Some queries that filter all rows are slow.
> -------------------------------------------
>
> Key: PHOENIX-1292
> URL: https://issues.apache.org/jira/browse/PHOENIX-1292
> Project: Phoenix
> Issue Type: Bug
> Reporter: Lars Hofhansl
>
> Sorry for the vague title.
> As mentioned PHOENIX-1281, I have seen some runtime anomalies for queries that should take similar amounts of time.
> 40m row tables, 4 integer column + integer key. All columns (except keys set to 1)
> |select distinct(v1) from x where v1 = 1 |21s|
> |select distinct(v1) from x where v1 <> 1 |50s|
> |select count(\*) from x where v1 <> 1 |45s|
> |select count(\*) from x where v1 = 1 |9.5s|
> Interestingly the queries that filter all rows are 5x slower.
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)