hive-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Xuefu Zhang <xzh...@cloudera.com>
Subject Re: Set variable via query
Date Wed, 14 Jan 2015 02:48:06 GMT
select * from someothertable where dt IN (select max(dt) from sometable);

On Tue, Jan 13, 2015 at 4:39 PM, Martin, Nick <NiMartin@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
>

Mime
View raw message