[
https://issues.apache.org/jira/browse/PHOENIX-1292?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14314759#comment-14314759
]
James Taylor commented on PHOENIX-1292:
---------------------------------------
[~lhofhansl] - what should we do with this JIRA?
> 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)
