Phoenix Count query produces many requests to HBase

[#1]

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

[#2]

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