Sign up to take part
Registered users can ask their own questions, contribute to discussions, and be part of the Community!
Registered users can ask their own questions, contribute to discussions, and be part of the Community!
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