Archives of Support Questions (Read Only)

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

Archives of Support Questions (Read Only)

Viewing Hive Column or Table level Statistics