DtypeWarning. Columns have mixed types

Gustavo_Brian
Gustavo_Brian Registered Posts: 10 ✭✭✭✭
Hi,

I have checked whole flow for the column '0' and is set to 'string' and 'Text' everywhere. Sadly when this data is dump to SQL Table values are converted to "int"

Any idea?
Tagged:

Answers

  • ikr_am
    ikr_am Registered Posts: 2 ✭✭

    Hi. I have the same problem with my data. In my case, the meaning is right not the type, it's changing after every recipe. The type String is changed to Int witch is correct but sometimes to Bigint. This type 'BigInt' is causing errors in my data…. Dataiku doesn't detect that as an error, the scenario is unfolding correctly but some columns are presenting an error without any notification.I have more than 600 columns is there any solution to avoid that, I m forced to check my data every time the scenario is unfolding…:/

    image.png
Setup Info
    Tags
      Help me…