[HIVE-9143] select user(), current_user()

• Type: Improvement
• Status: Closed
• Priority: Minor
• Resolution: Fixed
• Affects Version/s: 0.13.0
• Fix Version/s: 1.2.0

Release Note

Adds a UDF current_user that returns current user name
Example -
{code}
hive> select current_user();
OK
thejas
Time taken: 1.786 seconds, Fetched: 1 row(s)
{code}

• Assignee: Alexander Pivovarov
• Reporter: Hari Sekhon
• Created: 17/Dec/14 14:30
• Updated: 28/Jun/16 09:34
• Resolved: 06/Feb/15 01:41

Description

Feature request to add support for determining in HQL session which user I am currently connected as - an old MySQL ability:

mysql> select user(), current_user();
+----------------+----------------+
| user()         | current_user() |
+----------------+----------------+
| root@localhost | root@localhost |
+----------------+----------------+
1 row in set (0.00 sec)

which doesn't seem to have a counterpart in Hive at this time:

0: jdbc:hive2://<host>:100> select user();
Error: Error while compiling statement: FAILED: SemanticException Line 0:-1 Invalid function 'user' (state=42000,code=40000)
0: jdbc:hive2://<host>:100> select current_user();
Error: Error while compiling statement: FAILED: SemanticException [Error 10011]: Line 1:7 Invalid function 'current_user' (state=42000,code=10011)

Regards,

Hari Sekhon
http://www.linkedin.com/in/harisekhon

Issue Links

• relates to: HIVE-14100 Adding a new logged_in_user() UDF which returns the user provided when connecting
• relates to: HIVE-13085 Need an API / configuration parameter to find out the authenticated user from beeline
• links to: https://reviews.apache.org/r/30487/