RE: Set variable via query

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

Re: Set variable via query

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

Set variable via query

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 sometable'; select * from someothertable where dt=${hiveconf:startdt}; I found this is still open HIVE-2165