29 August 2018 · DataFreak ·       Add to Favorites   Report

BigQuery Error: No matching signature for function IFNULL

Getting error when using IFNULL Function?

Error: No matching signature for function IFNULL for argument types: STRING, INT64. 
Supported signature: IFNULL(ANY, ANY) at [4:9]

Solution:

While using the IFNULL function, make sure to have the same datatype as the column that you are checking nulls for. In the below example, if you are checking for NULLs in a string column, make sure to use a string data type as a substitution value as well

IFNULL(value.string_value, CAST(value.int_value AS STRING)) AS NewColumn

Read great educational content like this and a lot more !

Members get free exclusive access to content, new courses, and discounts. Signup for a free account to write a post / comment / upvote posts. Creating an account takes less than 5 seconds and you can start earning badges & points too

Copied