Thanks Arun you are right.
Sent from my iPhone
On Oct 12, 2012, at 11:26 AM, Arun Ahuja wrote:
> From my interpretation Hive coaelsce returns the first non-null value.
>
> So it seems you are just doing a null check on x and return y if it is
> null and z otherwise?
>
> In Pig you could do s
>From my interpretation Hive coaelsce returns the first non-null value.
So it seems you are just doing a null check on x and return y if it is
null and z otherwise?
In Pig you could do something like --- " (x is null ? y : z) This a
standard ternary if/else. Don't see if the 0.00 actually plays
Hi all,
How to Hive coalesce statement in pig
Example:
Case when
Coalesce(x,0.00)=0.00 then y else z
How to write this in pig
Regards
Abhi
hi all,
I am fairly new to pig.Can any one tell me how to write below hive
query in pig latin.
In this query iam using Cartesian join to achieve instring or contains in java.
Example
col1 -- 145678341212
col2 -- %67834%
insert into table t1
select t2.col1, t3.col2
from table2 t2
join table
