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

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
>

I'm using Hive 0.7.0. Yeah, this is out of my expectation.

On Fri, Aug 31, 2012 at 5:05 PM, Edward Capriolo <[EMAIL PROTECTED]> wrote:
> 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
>>