CASE...WHEN

Basic CASE Statement
CASE Query Statement

Parent topic: Spark SQL Syntax Reference