`Fill empty cells` step in Preparation generates bad BigQuery SQL

UgoD
UgoD Registered Posts: 9 ✭✭✭
edited July 16 in Using Dataiku

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

Tagged:
Setup Info
    Tags
      Help me…