@Srikanth Puli Please, have a look at this: https://cwiki.apache.org/confluence/display/Hive/StatsDev#StatsDev-ExistingTables–ANALYZE For a non-partitioned table, you can issue the command: ANALYZE TABLE Table1 COMPUTE STATISTICS FOR COLUMNS; to gather column statistics of the table (Hive 0.10.0 and later). If Table1 is a partitioned table, then for basic statistics you have to specify partition specifications like above in the analyze statement. Otherwise a semantic analyzer exception will be thrown. However for column statistics, if no partition specification is given in the analyze statement, statistics for all partitions are computed. You can view the stored statistics by issuing the DESCRIBE command. Statistics are stored in the Parameters array. Suppose you issue the analyze command for the whole table Table1, then issue the command: DESCRIBE EXTENDED TABLE1; then among the output, the following would be displayed: ... , parameters:{numPartitions=4, numFiles=16, numRows=2000, totalSize=16384, ...}, .... I hope this helps.
... View more
