select * from someothertable where dt IN (select max(dt) from sometable);
On Tue, Jan 13, 2015 at 4:39 PM, Martin, Nick <nimar...@pssd.com> 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 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
>
