question Re: CASE statement Error in Beeline HIVE in Archives of Support Questions (Read Only)

CASE statement Error in Beeline HIVE

Gayathridevi — Wed, 27 Sep 2017 17:36:44 GMT

Re: CASE statement Error in Beeline HIVE

balavignesh_nag — Wed, 27 Sep 2017 19:53:10 GMT

You have missed end in the statement. This should work.

case when hour(split(split(hbid,"#")[1],"_")[1])==0<br>then concat(split(split(split(hbid,"#")[1],"_")[1]," ")[0],"/","0-2") else 'NA' end

Hope it helps!!

Re: CASE statement Error in Beeline HIVE

balavignesh_nag — Thu, 28 Sep 2017 16:25:09 GMT

Hi @Gayathri Devi

sample nested case which can be used in hive.

Select case 
when hour(split(split(hbid,"#")[1],"_")[1])== 0 then concat(split(split(split(hbid,"#")[1],"_")[1]," ")[0],"/","0-2") 
when hour(split(split(hbid,"#")[1],"_")[1]) ==1 then concat(split(split(split(hbid,"#")[1],"_")[1]," ")[0],"/","0-2")]
when hour(split(split(hbid,"#")[1],"_")[1]) ==2 then concat(split(split(split(hbid,"#")[1],"_")[1]," ")[0],"/","2-4")]
when hour(split(split(hbid,"#")[1],"_")[1]) ==2 then concat(split(split(split(hbid,"#")[1],"_")[1]," ")[0],"/","2-4")]
when hour(split(split(hbid,"#")[1],"_")[1]) ==3 then concat(split(split(split(hbid,"#")[1],"_")[1]," ")[0],"/","2-4")]
else 'NA'
end as column1 from table_name;

If it helps then please accept it as the best answer! Happy Hadooping!!

Re: CASE statement Error in Beeline HIVE

Gayathridevi — Thu, 28 Sep 2017 16:28:53 GMT

Will Try and let u know. thanks a lot.