Phoenix Count query produces many requests to HBase

jakub_h — Tue, 30 Jan 2024 11:46:20 GMT

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 query

Re: Phoenix Count query produces many requests to HBase

DianaTorres — Tue, 30 Jan 2024 19:12:45 GMT

@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.

question Re: Phoenix Count query produces many requests to HBase in Support Questions

Phoenix Count query produces many requests to HBase

Re: Phoenix Count query produces many requests to HBase