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 <lan...@microstrategy.com>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**** > > ANALYZE TABLE [TABLENAME] PARTITION(parcol1=…, partcol2=….) COMPUTE > STATISTICS**** > > 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