hive-issues mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Xuefu Zhang (JIRA)" <j...@apache.org>
Subject [jira] [Commented] (HIVE-10656) Beeline set var=value not carrying over to queries
Date Mon, 18 May 2015 17:44:59 GMT

    [ https://issues.apache.org/jira/browse/HIVE-10656?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14548387#comment-14548387
] 

Xuefu Zhang commented on HIVE-10656:
------------------------------------

[~sircodesalot], I think hiveconf is default if the name space part of a variable is not given.
Thus, ${key} is equal to ${hiveconf:key} and "set key=value" is equal to "set hiveconf:key=value".

Please refer to documentation https://cwiki.apache.org/confluence/display/Hive/LanguageManual+VariableSubstitution.
To further make sure, please also check Hive CLI's behavior.

> Beeline set var=value not carrying over to queries
> --------------------------------------------------
>
>                 Key: HIVE-10656
>                 URL: https://issues.apache.org/jira/browse/HIVE-10656
>             Project: Hive
>          Issue Type: Bug
>            Reporter: Reuben Kuhnert
>            Priority: Minor
>
> After performing a {{set name=value}} I would expect that the variable name would carry
over to all locations within the session. It appears to work when querying the value via {{set;}},
but not when trying to do actual sql statements.
> Example:
> {code}
> 0: jdbc:hive2://localhost:10000> set foo;
> +----------+--+
> |   set    |
> +----------+--+
> | foo=bar  |
> +----------+--+
> 1 row selected (0.932 seconds)
> 0: jdbc:hive2://localhost:10000> select * from ${foo};
> Error: Error while compiling statement: FAILED: SemanticException [Error 10001]: Line
1:14 Table not found 'bar' (state=42S02,code=10001)
> 0: jdbc:hive2://localhost:10000> show tables;
> +------------+--+
> |  tab_name  |
> +------------+--+
> | my         |
> | purchases  |
> +------------+--+
> 2 rows selected (0.437 seconds)
> 0: jdbc:hive2://localhost:10000> set foo=my;
> No rows affected (0.017 seconds)
> 0: jdbc:hive2://localhost:10000> set foo;
> +---------+--+
> |   set   |
> +---------+--+
> | foo=my  |
> +---------+--+
> 1 row selected (0.02 seconds)
> 0: jdbc:hive2://localhost:10000> select * from ${foo};
> select * from ${foo};
> Error: Error while compiling statement: FAILED: SemanticException [Error 10001]: Line
1:14 Table not found 'bar' (state=42S02,code=10001)
> {code}



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)

Mime
View raw message