Set variable via query

[Martin, Nick]

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