hive-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Hari Sekhon (JIRA)" <j...@apache.org>
Subject [jira] [Updated] (HIVE-9143) select user(), current_user()
Date Wed, 17 Dec 2014 14:34:13 GMT

     [ https://issues.apache.org/jira/browse/HIVE-9143?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]

Hari Sekhon updated HIVE-9143:
------------------------------
    Description: 
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

  was:
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


> 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 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)

Mime
View raw message