usually explain a query on the table or describe formatted on the table shows whether stats is 'accurate'. can also do describe formatted xxx column xxx; to have an idea if it is correct or not on the column ... View more

The main purpose of it is to prevent overloading hdfs? If a query generates more than default #100000, it is better user examine the query and see why so. maybe the query is generating too many too small files. ... View more