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.

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
<[EMAIL PROTECTED]> 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.

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 <[EMAIL PROTECTED]>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
> <[EMAIL PROTECTED]> 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.
>

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
> <[EMAIL PROTECTED] <mailto:[EMAIL PROTECTED]>> 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
>     <[EMAIL PROTECTED] <mailto:[EMAIL PROTECTED]>> 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.
>
>

Thanks Kwangjin...

On Fri, Sep 14, 2012 at 9:53 AM, Kwangjin Oh <[EMAIL PROTECTED]> 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 <[EMAIL PROTECTED]>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
>> <[EMAIL PROTECTED]> 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.
>>
>
>
>