Creating a Hive table using “CASE WHEN”
I am trying to create a table T. I am stuck in the following condition: -
If column a of table S is 1 (S.a = 'T') then S.b will populate T.b and S.c will populate T.c.
If column a of table S is 0 (S.a = 'N') then S.b will populate T.d and S.c will populate T.e
I have tried using "case when" but that gives me 2 rows. I need to keep just 1 row.