Assuming that I have the following piece of code in the SELECT clause which is being executed on Spark:
... MEAN(CASE WHEN (col1 = 'A' AND (col3 = 'A' OR col4 = 'B')) THEN col2 END) AS testing, ...
What would be the output of this query when
NULL? Are the rows containing
col2=NULL be ignored by the