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

Options
tasosventouris
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

Tagged:

Answers

Setup Info
    Tags
      Help me…