This time we did show table stats and show column stats on the table before the issue ( just after the restart and before running invalidate metadata) and then after the restart and we do not notice any difference in output but problem reoccurred this time also.  To understand the sequence of events : (1) Admin team does patching and restart the cluster (2) application team run a distinct year query and sees out of 31 only 27 rows are present and 4 of the partitions are missing.  (3) as a support team, I run show stats which shows all 31 partitions and number of rows in partitions is correct and size also. (4) we run invalidate metadata and refresh (5) support team takes show stats which has same result (6) app team runs they query again and they able to see all 31 partitions.   we will work with vendor to get further help.  ... View more

@npr20202, Have you resolved your issue? If so, can you please provide the solution here? It will help others who are seeking answers to similar queries.  If you are still experiencing the issue, can you provide the information @willx  has requested? ... View more