hive-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Amila Maha Arachchi <amila.m...@gmail.com>
Subject Re: How to use the IF conditional function in Hive scripts
Date Fri, 14 Sep 2012 04:44:57 GMT
Thanks Kwangjin...

On Fri, Sep 14, 2012 at 9:53 AM, Kwangjin Oh <kjin.oh@gmail.com> wrote:

>  hive> create table test ( foo string, bar int ) ;
> hive> select foo, IF(bar = 0, 'zero', 'not zero') from test;
>
>
> http://www.folkstalk.com/2011/11/conditional-functions-in-hive.html
>
>
>
> On 2012-09-14 오후 1:13, Amila Maha Arachchi wrote:
>
> Hi Ruslan,
>
>  Thanks for youe reply. Can you please let me know in which situations we
> can use the IF conditional function (or the CASE function)? Pointing to a
> sample script would be enough.
>
>  Thanks,
> Amila.
>
> On Fri, Sep 14, 2012 at 2:27 AM, Ruslan Al-Fakikh <metaruslan@gmail.com>wrote:
>
>> Hi,
>>
>> I guess this goes beyond Hive scripts. You can use some kind of an
>> external automation tool like Oozie or a wrapper sh script
>>
>> Ruslan
>>
>> On Thu, Sep 13, 2012 at 3:49 PM, Amila Maha Arachchi
>> <amila.maha@gmail.com> wrote:
>> > Hi,
>> >
>> > I am trying to write a hive script which is doing some summarization.
>> There
>> > are two summarizations hourly and daily. I want to run the hourly
>> > summarization first, then check whether the current timestamp matches
>> some
>> > value of my favour (lets say 2012-09-13 23:00:00) and run the daily
>> > summarization.
>> >
>> > My question is, can I use the IF conditional function which is
>> mentioned in
>> > [1]. I could not fined any examples on this.
>> >
>> >
>> > [1]
>> >
>> https://cwiki.apache.org/Hive/languagemanual-udf.html#LanguageManualUDF-ConditionalFunctions
>> >
>> > Thanks,
>> > Amila.
>>
>
>
>

Mime
View raw message