RE: Hive Meta Information

2012-04-03 Thread Ladda, Anand
ginal Message- From: Thiruvel Thirumoolan [mailto:thiru...@yahoo-inc.com] Sent: Monday, April 02, 2012 5:47 AM To: user@hive.apache.org Subject: Re: Hive Meta Information > 1. recent users of table, > 2. top users of table, Hive metastore has audit support (HIVE-1948). While

Re: Hive Meta Information

2012-04-02 Thread Thiruvel Thirumoolan
> 1. recent users of table, > 2. top users of table, Hive metastore has audit support (HIVE-1948). While what Edward suggests will be accurate, audit log might give you a superset of that, it will also include "desc table" requests. Thiruvel On 3/31/12 8:39 PM, "Edward Capriolo" w

Re: Hive Meta Information

2012-03-31 Thread Edward Capriolo
hive does not capture this information. I have a tool on github that connects to the JobTracker and pulls stat information. https://github.com/edwardcapriolo/hadoop_cluster_profiler It would be pretty easy to add code to record some of information you are looking for. Hive is close to #4 with a

Re: Hive Meta Information

2012-03-30 Thread Nitin Pawar
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