Lars Hofhansl created PHOENIX-1292:
--------------------------------------
Summary: 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)
