Two case when hive conditionals

user_16306765 0
Viewed 148

How can I perform two conditionals on the same CASE WHEN, for example:

CASE
    WHEN (column) LIKE '%IPHONE%' AND '%MOBILE%' THEN 'IOS'
    WHEN (column) LIKE '%ANDROID%' AND '%LINUX%' THEN 'ANDROID'
    WHEN (column) LIKE '%LINUX%' THEN 'DESKTOP'
    ELSE 'NA'
END

My record shows: Iphone; Mobile; Mac OS X; How can I give a LIKE query with two conditions (Iphone and Mobile)?

hiveql hive conditional-statements case sql
1 Answers
CASE
    WHEN (column LIKE '%IPHONE%') AND (column LIKE '%MOBILE%') THEN 'IOS'
    WHEN (column LIKE '%ANDROID%') AND (column LIKE '%LINUX%') THEN 'ANDROID'
    WHEN column LIKE '%LINUX%' THEN 'DESKTOP'
    ELSE 'NA'
END
user_27003440
Related