Home | About | Sematext search-lucene.com search-hadoop.com
 Search Hadoop and all its subprojects:

Switch to Plain View
Hive >> mail # user >> Hive Meta Information


+
Ladda, Anand 2012-03-30, 22:06
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
+
Edward Capriolo 2012-03-31, 15:09
+
Thiruvel Thirumoolan 2012-04-02, 09:47
+
Ladda, Anand 2012-04-03, 13:19