Home | About | Sematext search-lucene.com search-hadoop.com
 Search Hadoop and all its subprojects:

Switch to Threaded View
Hive >> mail # user >> Table Statistics In Hive

Copy link to this message
Re: Table Statistics In Hive
I am not sure of this but just making a guess from what i have learned

for getting row count i always run select count(1) from table

desc extended table tells the entire table metadata information but nothing
about the records inside the table

On Mon, Apr 2, 2012 at 9:20 PM, Ladda, Anand <[EMAIL PROTECTED]>wrote:

>  I’ve tried to collect statistics on an existing table in hive using the
> commands mentioned in this wiki page -
> https://cwiki.apache.org/confluence/display/Hive/StatsDev****
> But when I do a DESCRIBE EXTENDED [TABLENAME] after the stats collection
> has been completed, I see the number of rows is still 0. Is there anything
> I am missing here? I am using Hive 0.7.1****
> Thanks****
> Anand****

Nitin Pawar