Re: How to use the IF conditional function in Hive scripts

[Kwangjin Oh]

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 <metarus...@gmail.com <mailto:metarus...@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.m...@gmail.com <mailto:amila.m...@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.