Count(*) not working on Hbase mapped Hive Table

[#1]

I've a Hbase mapped Hive table which retrieves rows when I run

select * from my_table;

But when I execute

select count(*) from my_table; 

the output is 0.

What must be the issue in this case ?

[#2 · Accepted solution]

@Prathamesh H

Instead of select count(*) use

select count(<column_name>) from my_table; 

this command will display number of rows in the hive-hbase table.

-

If the answer is helpful to resolve the issue, Click on Accept button below to close this thread.This will help other community users to find answers quickly :-).

[#3]

The above querstion and the entire reply thread below was originally posted in the Community Help Track. On Tue Jun 4 03:55 UTC 2019, a member of the HCC moderation staff moved it to the Data Processing track. The Community Help Track is intended for questions about using the HCC site itself.