Apache Phoenix - Count query returns more than 100k rows, but SELECT query does not return any row

Question

Using Apache Spark 3, I manipulated some CSV data, stored in a dataframe, with the intention of sending it to HBase.

The data is successfully sent using JavaHBaseContext's bulkPut() method.

However, in Apache Phoenix, using a plain SELECT query, I get the message 'No rows selected'.

When I run SELECT count(*) query, I get:

Meanwhile, HBase's shell allows to ensure the availability of data as expected.

What could be the problem?