Re: Variable Substitution

2013-03-06 Thread Matt Tucker
I'm fine with the variable placeholder not being removed in cases where the variable is not defined (until I change my mind). When I define var2 and var3, though, their placeholders aren't swapped for their values. My reasoning for this was that I'm moving from one execution script that defines

Re: Variable Substitution

2013-03-06 Thread Edward Capriolo
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. Any reason

Re: Variable Substitution

2013-03-06 Thread Dean Wampler
Even newer versions of Hive do this. Any reason you don't want to provide a definition for all of them? You could argue that an undefined variable is a bug and leaving the literal text in place makes it easier to notice. Although, Unix shells would insert an empty string, so never mind ;) On Wed,

Re: variable substitution doesn't for table name?

2012-08-31 Thread Yue Guan
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, Yue Guan wrote: >> Hi, there

Re: variable substitution doesn't for table name?

2012-08-31 Thread Edward Capriolo
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; > explain select * from ${h

RE: Variable Substitution Depth Limit

2012-03-30 Thread Tucker, Matt
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

RE: Variable Substitution Depth Limit

2012-03-30 Thread carla.staeben
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

RE: Variable Substitution Depth Limit

2012-03-30 Thread carla.staeben
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

Re: Variable Substitution Depth Limit

2012-03-30 Thread Edward Capriolo
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 it configurable by a hive-site property. On Fri, Mar 30, 2012 at 10:59 AM, Tucker, Matt wrote: > I’m trying to m