If you’re working on a numeric/integer column and decided to substitute null values with zero, there’s a straight forward function that solves the issue. The
Tag: ZEROIFNULL function in Apache Impala
Handling NULL in Apache Impala
An significant part is the treatment of NULL values during data processing and reports. Sometimes it ends up with arithmetic overflow errors or null values
Big Data & SQL 