BatchUpdateException: Data truncation: Data too long for column 'content' at row 130

tasosventouris Registered Posts: 15 ✭✭✭

I have a MariaDB table where I try to write results of an RSS that I fetch through a Python recipe. I get the error of the title that the column "content" is too long.

When I open the dataset and check the schema, it is like this:
"name": "content",
"type": "string",
"originalType": "LONGTEXT",
"maxLength": -1,
"$idx": 6,
"$selected": true

However, after I run the recipe and it fails, the "maxLength" changes to 500. I created the table myself and I used LONGTEXT, but now (after Python recipe) when I check the table directly to the database, it is VARCHAR(500)

I tried with both `write_from_dataframe` and `write_with_schema` functions



Setup Info
      Help me…