hive-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Devopam Mittra <>
Subject Re: audit hive query
Date Mon, 22 Sep 2014 16:08:14 GMT
hi Siva,
If I were to address your problem, I will create a table in hive metastore
DB , and load the Hive query text + timing in it , by writing my own custom
shell script.

And I will need to do this on all hive client machines (not just one) ,
maybe by suitably adding $HOSTNAME as another variable.

If I have Java programs calling Hive SQL queries , I may need to suitably
log it separately as well.

Hope it helps.


On Mon, Sep 22, 2014 at 6:15 PM, siva kumar <> wrote:

> Hi Dev,
>             When i run the hive query in hive shell, the query is stored
> in hive history file at default location.Since my metastore is sql for hive
> whenever i create a table with some columns in hive shell,it gets populated
> in sql metastore database.Simillarly,all the queries should be popoulated
> in a sql table. I want to view the hive queries over a period of
> time populated in a sql table, but not through the web browser. Can
> u suggest me some idea on dis scenario.
> Thanks and regards,
> siva
> On Mon, Sep 22, 2014 at 9:18 AM, Devopam Mittra <> wrote:
>> Please check .hivehistory settings and it might be of easy / simple good
>> help .
>> If you are on Ambari based installation then simply looking into Resource
>> Manager UI should suffice the need.
>> If you are on native hadoop, then you can access the Yarn log through web
>> browser as well.
>> Hope this helps
>> regards
>> Dev
>> On Fri, Sep 19, 2014 at 4:01 PM, siva kumar <> wrote:
>>> Hi All,
>>>           I have a requirement to view the recently executed Hive
>>> queries in sql. I have configured sql as metastore to hive and im able to
>>> view hive tables,columns,partitions in sql . Simillarly,i need to view
>>> the hive queries executed on hive data.
>>> Any help is appreciated,
>>> sivakumar.c
>> --
>> Devopam Mittra
>> Life and Relations are not binary

Devopam Mittra
Life and Relations are not binary

View raw message