Support Questions

Find answers, ask questions, and share your expertise
Announcements
Celebrating as our community reaches 100,000 members! Thank you!

Viewing Hive Column or Table level Statistics

avatar
Expert Contributor

Does anyone know of a way to view the statistics which are created after the command "analyze table [myTable] compute statistics;" is executed?

Referenced from here: http://hortonworks.com/blog/5-ways-make-hive-queries-run-faster/

1 ACCEPTED SOLUTION

avatar

@Wes Floyd Here is Hive Stats detail https://cwiki.apache.org/confluence/display/Hive/S...

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, ...}, ....

View solution in original post

10 REPLIES 10

avatar
Super Collaborator