You are viewing a plain text version of this content. The canonical link for it is here.

Posted to user@phoenix.apache.org by cmbendre <ch...@zeotap.com> on 2017/05/25 10:43:36 UTC

Re: Speeding Up Group By Queries

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.