How to determine who ran query if Hive Impersonations = False?

[#1]

I have hive impersonations set to false. Is there a simple way of determining who ran the job/query?

[#2 · Accepted solution]

Hi Sunile,

You can use a Hive hook to determine who submitted the query, even with doAs=false. As an example you can even use that to direct the query to an specific YARN queue. See the following for more info:

https://github.com/beto983/Hive-Utils/blob/master/README.md

[#3]

@Alberto Romero

Notice that if you are re-using initialized sessions (hive.server2.tez.initialize.default.sessions) this solution will not work, because the properties are created only when the AM starts. When you use default sessions the AM will be created before your hook can define a custom property.

The hook solution work for non-default tez sessions and also for map-reduce.

Find here some rest calls to RM API that works for all Tez scenarios (but not for map-reduce engine).

[#4]

@Guilherme Braccialli Indeed, the hook is for not reusing initialised sessions.

Thanks very much for sharing the REST calls. Look quite useful to have handy.

[#5]

Thanks to @Guilherme Braccialli I found it can be done via tez api calls.

some examples thanks to @Guilherme Braccialli

http://myserver.com:8188/ws/v1/timeline/HIVE_QUERY_ID/hive_20160330062211_6917b0b2-a34f-4735-b332-57...

http://myserver.com:8188/ws/v1/timeline/HIVE_QUERY_ID/hive_20160330064546_192ee370-d548-44fc-8073-90...