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 Threaded View
Hive >> mail # user >> Hive Meta Information


Copy link to this message
-
Re: Hive Meta Information
Anand,

I doubt this information is readily available in hive as this is not meta
information rather access information.

For number of records in a table you can just run a query like select
count(1) from table;
For the access details on table data, you will need to process hadoop logs
and based on that you can figure out who accessed the data and how

Thanks,
Nitin

On Sat, Mar 31, 2012 at 3:36 AM, Ladda, Anand <[EMAIL PROTECTED]>wrote:

>  How do I get the following meta information about a table****
>
> **1.       **recent users of table, ****
>
> **2.       **top users of table, ****
>
> **3.       **recent queries/jobs/reports, ****
>
> **4.       **number of rows in a table****
>
> ** **
>
> I don’t see anything either in DESCRIBE FORMATTED or SHOW TABLE EXTENDED
> LIKE commands. ****
>
> 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