re that having 1 variable reference that's not defined should prevent
the others from working.
On Mar 6, 2013, at 4:41 PM, Edward Capriolo wrote:
> It was done like this in hive because that is what hadoops variable
> substitution does, namely if it does not understand the variable
It was done like this in hive because that is what hadoops variable
substitution does, namely if it does not understand the variable it does
not replace it.
On Wed, Mar 6, 2013 at 4:30 PM, Dean Wampler <
dean.wamp...@thinkbiganalytics.com> wrote:
> Even newer versions of Hive do this. A
n Wed, Mar 6, 2013 at 3:13 PM, Matt Tucker wrote:
> Using CDH3u3 (Hive 0.7.1), it appears that variable substitution becomes
> disabled when I use a variable in a query that hasn't been defined.
>
> For instance, using the following script:
>
> set var2=2013-02-01;
>
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 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, Yu
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 wrote:
> Hi, there
>
> Is variable substitution good for tables? This is what I tried:
>
> set table_name=test_table;
> exp
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 onl
That did the trick.
Thanks Carla!
Matt Tucker
-Original Message-
From: carla.stae...@nokia.com [mailto:carla.stae...@nokia.com]
Sent: Friday, March 30, 2012 11:31 AM
To: user@hive.apache.org
Subject: RE: Variable Substitution Depth Limit
Sorry, hit send too fast...As a work around for
ton)
Sent: Friday, March 30, 2012 11:30
To: user@hive.apache.org
Subject: RE: Variable Substitution Depth Limit
Yeah, you're not the only one who's run into that issue. There is an open Jira
item for it, so they're aware we'd like it configurable anyway...
https://issues.ap
l.com]
Sent: Friday, March 30, 2012 11:19
To: user@hive.apache.org
Subject: Re: Variable Substitution Depth Limit
Unfortunately you are going to have to roll your own hive. It was just
a concept we borrowed from Hadoop since it does not support more then
40 depth substitution. We can probably make
ery to join all of the tables and select all of the
> appropriate columns. In this query, I reference the ${hiveconf:table}
> variable 122 times, and end up receiving this error:
> “java.lang.IllegalStateException: Variable substitution depth too large:
> 40”. According to a quick Goog
tables and select all of the appropriate
columns. In this query, I reference the ${hiveconf:table} variable 122 times,
and end up receiving this error: "java.lang.IllegalStateException: Variable
substitution depth too large: 40". According to a quick Google search, it
appears tha
11 matches
Mail list logo
