Skip to main content
jakub_h
Bronze ⭐️⭐️⭐️
January 30, 2024
Question

Phoenix Count query produces many requests to HBase

I am running count(*) from table (Apache Phoenix 5.1, HBase2), it results in high number of requests in HBase

1,4k requests for table with 7k rows

In previous version (Hortonworks, Hbase 1.1, Phoenix 4.7)  count query was not resulting such high number of requests in HBase.

tried (major) compaction and updating Phoenix statistics, not helped.

Is this expected or miss some configuration? obviously it makes fullscan even when there is primary key for the table

HBase UI x Count queryHBase UI x Count query

1 reply

DianaTorres
Community Manager
Community Manager
January 30, 2024

@jakub_h Welcome to the Cloudera Community!

To help you get the best possible solution, I have tagged our Phoenix experts @smdas @ChrisGe  who may be able to assist you further.

Please keep us updated on your post, and we hope you find a satisfactory solution to your query.

Translate
Regards, Diana Torres, Senior Community Moderator