Home | About | Sematext search-lucene.com search-hadoop.com
NEW: Monitor These Apps!
elasticsearch, apache solr, apache hbase, hadoop, redis, casssandra, amazon cloudwatch, mysql, memcached, apache kafka, apache zookeeper, apache storm, ubuntu, centOS, red hat, debian, puppet labs, java, senseiDB
 Search Hadoop and all its subprojects:

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


+
Ladda, Anand 2012-04-02, 15:50
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****
>
> 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
NEW: Monitor These Apps!
elasticsearch, apache solr, apache hbase, hadoop, redis, casssandra, amazon cloudwatch, mysql, memcached, apache kafka, apache zookeeper, apache storm, ubuntu, centOS, red hat, debian, puppet labs, java, senseiDB