phoenix-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From cmbendre <>
Subject Re: Speeding Up Group By Queries
Date Thu, 25 May 2017 10:43:36 GMT

I am observing a similar behavior.I am doing POC of Phoenix since our query
workloads are a mix of point lookups and aggregations.

As i can see, Phoenix performs well on point lookups based on either PK or
secondary index. But when it comes to aggregations, it has to do a full scan
and its slow.

Our productions setting will have 500 million - 1 billion rows. And it will
grows over the time. I tried all the the tuning in this thread but still
group by queries are slow. ( Although this is a small cluster with 2
regionServers with 6 GB RAM and 4 cores each)

Is increasing number of machines the only choice we have if we want to
support sub-second group by queries ?


View this message in context:
Sent from the Apache Phoenix User List mailing list archive at

View raw message