SQL Interpreter & Optimizer handles the functional programming part of Spark SQL. It transforms the DataFrames RDDs to get the required results in the required formats.
Some of it's Features are:
- Functional programming
 
- Transforming trees
 
- Faster than RDDs
 
- Processes all size data
 
e.g. Catalyst: A modular library for distinct optimization