Question
How does Spark SQL normally treat a comparison with NULL using ordinary equality?
Select an option. Your answer will be checked instantly.
Correct Answer: B. It yields unknown rather than true, so null-specific functions are needed
Explanation:
SQL uses three-valued logic for nulls.
Functions such as isNull or null-safe equality express the intended test.
Leave a Reply