question Count(*) not working on Hbase mapped Hive Table in Support Questions

Count(*) not working on Hbase mapped Hive Table

prathamesh_h — Sat, 17 Aug 2019 22:11:32 GMT

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 ?

Re: Count(*) not working on Hbase mapped Hive Table

Shu_ashu — Sat, 01 Jun 2019 22:42:16 GMT

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

Re: Count(*) not working on Hbase mapped Hive Table

ask_bill_brooks — Tue, 04 Jun 2019 10:56:19 GMT

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.