[SPARK-3813] Support "case when" conditional functions in Spark SQL

• Type: Improvement
• Status: Resolved
• Priority: Major
• Resolution: Fixed
• Affects Version/s: 1.1.0
• Fix Version/s: 1.2.0
• Component/s: SQL
• Assignee: Ravindra Pesala
• Reporter: Ravindra Pesala
• Created: 06/Oct/14 12:24
• Updated: 25/Jun/15 16:11
• Resolved: 09/Oct/14 22:15

Description

The SQL queries which has following conditional functions are not supported in Spark SQL.

CASE a WHEN b THEN c [WHEN d THEN e]* [ELSE f] END
CASE WHEN a THEN b [WHEN c THEN d]* [ELSE e] END

The same functions can work in Spark HiveQL.

Issue Links

• relates to: SPARK-8636 CaseKeyWhen has incorrect NULL handling
• links to: [Github] Pull Request #2678 (ravipesala)