Support Questions
Find answers, ask questions, and share your expertise
Announcements
Check out our newest addition to the community, the Cloudera Innovation Accelerator group hub.

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

Explorer

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

3 REPLIES 3

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)

Mentor

@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

hive.compute.query.using.stats=false

Restart the stale configurations and retest?

Please revert.

Mentor

@AnjiReddy Anumolu

Any updates?