I have one partitioned table. Some times I observed that even if I have data in some partition, e.g. "select count(*) from TABLE"on table gives me output as zero.

And if I do count(*) on that partition e.g. - "select count(*) from TABLE partition (partition_name)", I get the correct count.

Why am I not getting the actual count when I do the count(*) on table?

Please if anybody has any clue about this, plet me know.