[
https://issues.apache.org/jira/browse/HIVE-9143?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Thejas M Nair updated HIVE-9143:
--------------------------------
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}
was:Returns current user name
[~leftylev] What would be a good place to document this.
I have updated the release notes.
> 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
> Assignee: Alexander Pivovarov
> Priority: Minor
> Fix For: 1.2.0
>
> Attachments: HIVE-9143.1.patch, HIVE-9143.2.patch, HIVE-9143.3.patch
>
>
> Feature request to add support for determining in HQL 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)
