phoenix-user mailing list archives

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

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 ?

Thanks
Chaitanya



--
View this message in context: http://apache-phoenix-user-list.1124778.n5.nabble.com/Speeding-Up-Group-By-Queries-tp1434p3589.html
Sent from the Apache Phoenix User List mailing list archive at Nabble.com.

Mime
View raw message