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 -
https://cwiki.apache.org/confluence/display/Hive/StatsDev
ANALYZE TABLE [TABLENAME] PARTITION(parcol1=..., partcol2=) COMPUTE
STATISTICS
But when I do a DESCRIBE EXTENDED [TABLENAME