hive-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Martin, Nick" <NiMar...@pssd.com>
Subject Set variable via query
Date Wed, 14 Jan 2015 00:39:50 GMT
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<https://issues.apache.org/jira/browse/HIVE-2165>

Any options? Tried a flavor of above via CLI and it didn't work.

On Hive 13

Thanks!
Nick

Mime
View raw message