I am trying to add csv files to RDS MySQL database and successfully created my files in Glue Databrew, crawled them in Glue, but when I run my Job in Glue Studio I get an error: "An error occurred while calling o106.pyWriteDynamicFrame. Data truncation: Data too long for column [insertcolumnname] at row 1". I recreated the files in jupyter notebook and there are no columns with len >255 and most are around len~80 characters. A job for one of my tables (a very simple one) did successfully run and is in my MySQL database, but all the other tables fail with this error. What am I missing here?
AWS UFFICIALEAggiornata 2 anni fa