hive-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Reuben Kuhnert (JIRA)" <j...@apache.org>
Subject [jira] [Created] (HIVE-10656) Beeline set var=value not carrying over to queries
Date Fri, 08 May 2015 14:06:00 GMT
Reuben Kuhnert created HIVE-10656:
-------------------------------------

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