`Fill empty cells` step in Preparation generates bad BigQuery SQL
![UgoD](https://us.v-cdn.net/6038231/uploads/Dataiku/nAvatar10.png)
UgoD
Registered Posts: 9 ✭✭✭
Hi,
I'm using Dataiku 10.0.5, Python 3.6 and BigQuery.
I'm trying to fill empty cells of all my columns with 0, but it's not working correctly for some columns.
The first column it's not working with is a boolean column and the others are int (for both database and dataiku types)
When I look the SQL generated, it look like that:
com.dataiku.dss.shadelib.com.google.cloud.bigquery.BigQueryException: No matching signature for operator = for argument types: INT64, STRING. Supported signature: ANY = ANY
and the error I get is
CASE WHEN (`my_column` IS NULL OR (`my_column` = '')) THEN CAST('0' AS STRING) ELSE `my_column`
for the INT column (replace INT64 by BOOLEAN for the other error)
Seems to be normal, but I don't understand why all my INT64 typed columns don't get this error.
Do you have an way to avoid this error ? Am I doing smtg wrong ?
Best regards
Ugo
Operating system used: Windows 10
Operating system used: Windows 10