Hive Case statement examples

A CASE expression returns a value from the THEN portion of the clause. You could use it thusly:

Note that you need to do something with the returned value, e.g. compare it to 1. Your statement attempted to return the value of an assignment or test for equality, neither of which make sense in the context of a CASE/THEN clause. (If BOOLEAN was a datatype then the test for equality would make sense.)

 

http://stackoverflow.com/questions/10256848/can-i-use-case-statement-in-a-join-condition