Home | About | Sematext search-lucene.com search-hadoop.com
 Search Hadoop and all its subprojects:

Switch to Threaded View
Hive, mail # user - variable substitution doesn't for table name?


Copy link to this message
-
Re: variable substitution doesn't for table name?
Edward Capriolo 2012-08-31, 21:05
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 <[EMAIL PROTECTED]> 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
>