Hive Variable Substitution not working from hive -e command

Question

I am trying to use Hive variable.

If I login to Hive and use :

hive > set a=test_table;
hive > describe ${hiveconf:a};

But Same command if try from Shell , it gives : Parse Error 1:1 cannot recognize input near ...

$> hive -e "set a=test_table; describe ${hiveconf:a};"
Parse Error 1:1 cannot recognize input near <EOF>

http://stackoverflow.com/questions/12464636/how-to-set-variables-in-hive-scripts — Balaswamy Vaddeman, Mar 06 '13 at 06:45
$a directly is not working..it says cannot recognize input near describe. ref : http://archive.cloudera.com/cdh/3/hive/language_manual/var_substitution.html — Pradeep Bhadani, Mar 06 '13 at 06:50

score 0 · Answer 1 · edited Apr 10 '18 at 01:46

Parameter Expansion
   The `$' character introduces parameter expansion, command substitution, or arithmetic expansion.  The parameter name  or
   symbol  to  be  expanded  may be enclosed in braces, which are optional but serve to protect the variable to be expanded
   from characters immediately following it which could be interpreted as part of the name.

   When braces are used, the matching ending brace is the first `}' not escaped by a backslash or within a  quoted  string,
   and not within an embedded arithmetic expansion, command substitution, or parameter expansion.

   ${parameter}
          The  value  of  parameter  is substituted.  The braces are required when parameter is a positional parameter with
          more than one digit, or when parameter is followed by a character which is not to be interpreted as part  of  its
          name.

so : hive -e 'set a=test_table; desc ${hiveconf:a};'

score 0 · Answer 2 · answered Nov 03 '18 at 05:25

0

Try this:

hive --hiveconf a="test_table" -e "describe database.${hiveconf:a}"

answered Nov 03 '18 at 05:25

swapnil shashank

877
8
11

score -1 · Answer 3 · answered Mar 06 '13 at 06:53

-1

you have to code like below.

   >a=test_table
   >hive -e "describe $a"

Check language manual

answered Mar 06 '13 at 06:53

Balaswamy Vaddeman

8,360
3
30
40

Hive Variable Substitution not working from hive -e command

3 Answers3