hive-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Nitin Pawar <>
Subject Re: Table Statistics In Hive
Date Tue, 03 Apr 2012 07:43:59 GMT
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 <>wrote:

>  I’ve tried to collect statistics on an existing table in hive using the
> commands mentioned in this wiki page -
> 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

View raw message