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.