Support Questions

Find answers, ask questions, and share your expertise
Check out our newest addition to the community, the Cloudera Data Analytics (CDA) group hub.

Hive count(*) is not giving any results..?


i tired my luck with Analyze statements, still it is not giving any results.

when i triggered analyze statement the query is not executing at all, this is happening only for few tables in database.

Thanks in Advanche


Expert Contributor

Yes, this does happen if statistics etc. are out of sync. It is generally best practice to use a column identifier to get correct results like count(id)


@AnjiReddy Anumolu

That's weird are you sure that the tables you are trying to query had data?

select Count(1) from xxx;

This should pull everything from table xxx. Note the 1 instead of *

Can you set this in hive-site.xml


Restart the stale configurations and retest?

Please revert.


@AnjiReddy Anumolu

Any updates?

Take a Tour of the Community
Don't have an account?
Your experience may be limited. Sign in to explore more.