Thx..went with something similar-ish to fit the need.
From: Xuefu Zhang [mailto:xzh...@cloudera.com]
Sent: Tuesday, January 13, 2015 9:48 PM
To: user@hive.apache.org
Subject: Re: Set variable via query
select * from someothertable where dt IN (select max(dt) from sometable);
On Tue, Jan 13
select * from someothertable where dt IN (select max(dt) from sometable);
On Tue, Jan 13, 2015 at 4:39 PM, Martin, Nick wrote:
> Hi all,
>
> I'm looking to set a variable in Hive and use the resulting value in a
> subsequent query. Something like:
>
> set startdt='select max(dt) from sometabl
