DATABRICKS-SPARK Question 94

Community Discussion

Written by other learners. Comments can disagree with the marked answer — check the official documentation when in doubt.

• Chose A0

  - Spark treats null as a single distinct group value during GROUP BY — one aggregation row labeled with null. This is SQL-standard behavior. If you want to exclude nulls, filter them out before groupBy.