Hari Sekhon created HIVE-9143:
---------------------------------
Summary: select user(), current_user()
Key: HIVE-9143
URL: https://issues.apache.org/jira/browse/HIVE-9143
Project: Hive
Issue Type: Improvement
Affects Versions: 0.13.0
Reporter: Hari Sekhon
Priority: Minor
Feature request to add support for determining in SQL session which user I am
currently connected as - an old MySQL ability:
{code}mysql> select user(), current_user();
+----------------+----------------+
| user() | current_user() |
+----------------+----------------+
| root@localhost | root@localhost |
+----------------+----------------+
1 row in set (0.00 sec)
{code}
which doesn't seem to have a counterpart in Hive at this time:
{code}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){code}
Regards,
Hari Sekhon
http://www.linkedin.com/in/harisekhon
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
