No. Variable substitution works for anything. Likely your version of hive is old and does not support this at all.
On Friday, August 31, 2012, Yue Guan <pipeha...@gmail.com> wrote: > Hi, there > > Is variable substitution good for tables? This is what I tried: > > set table_name=test_table; > explain select * from ${hiveconf:table_name}; > > FAILED: Parse Error: line 1:22 cannot recognize input '$' in join source > > So I just want to confirm that variable substitution is only good for > column names? > > Thank you >