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 variab
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 pop
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
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