Discover this year's submissions to the Dataiku Frontrunner Awards and give kudos to your favorite use cases and success stories!READ MORE

Problem importing MYSQL tables to Dataiku (tinyint(1) columns)

Yasmine
Level 2
Problem importing MYSQL tables to Dataiku (tinyint(1) columns)

Hello,

I have MYSQL source data. While importing my data on Dataiku, I noticed that columns that are of type TINYINT(1) with possible values: 1, 2, 3, 4, ... 19 on MYSQL turn into Boolean columns on Dataiku with possible true or false values. So there is a conversion problem of the type TINYINT(1) when importing data to Dataiku.

I tried this solution that works well: apply the CAST function to all the columns concerned as soon as the tables were imported on Dataiku CAST (nom_colonne as SIGNED) but this solution required me several manual manipulations since I have several columns of type TINYINT(1) in my database. Do you have, please, an explanation and a lasting solution to this problem? there is no way to change the setting of my MYSQL connections?

Thanks in advance,

Best regards,

Yasmine

 

 

0 Kudos
0 Replies