Support Questions

wfloyd · ‎12-16-2015

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/

pardeep_kumar · ‎12-16-2015

@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

ekoifman · ‎09-12-2018

desc formatted <table> <column>

https://cwiki.apache.org/confluence/display/Hive/StatsDev#StatsDev-Examples

Cloudera Community

Support Questions

Viewing Hive Column or Table level Statistics