ZEROIFNULL Function in Apache Impala

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 function is ZEROIFNULL. This accepts a single argument and replaces the null values with zero if there is any.


Let’s implement this function on integer and decimal columns.



Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s