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

[#1]

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

[#2]

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)

[#3]

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

[#4]

@AnjiReddy Anumolu

Any updates?