This is done in a bunch of ways by different databases: https://www.w3schools.com/sql/sql_isnull.asp

It would be nice if pinot can support this capability. Right now this can only be done using CASE statement.

CASE when expr([cols]) is 'null' THEN fallback_value ELSE expr([cols]) END