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

Asked Dec 01 '21 at 17:34

Active Dec 09 '21 at 11:29

Viewed 249 times

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?

edited Dec 09 '21 at 11:29

asked Dec 01 '21 at 17:34

might be the schema is broken. – Lamanus Dec 02 '21 at 02:21
@Lamanus My colleague discovered that when the table is created with COLUMN_ENCODED_BYTES = 1, rows are not displayed. When the table is created with COLUMN_ENCODED_BYTES = 0, the rows are created but the columns are not aligned with data. – Mohamed Ennahdi El Idrissi Dec 02 '21 at 09:35

0 Answers0