"storing csv file data in database using Rapidminer"

Raman
Raman New Altair Community Member
edited November 2024 in Community Q&A
I want to store CSV file content in MYSQL database using Rapidminer. But the problem is -
Database error occured: attribute reviewText contains values with length>255 which is the maximum length for columns of SQL type VARCHAR.
and i also checked the set default varchar length. But it does not resolve my problem.

Answers

  • Marco_Boeck
    Marco_Boeck New Altair Community Member
    Hi,

    you have 2 options: Either during import change the column type to "text" or use the "Nominal to Text" operator before your "Write Database" operator. In both cases the resulting SQL column will be of a TEXT type.

    Regards,
    Marco
  • Raman
    Raman New Altair Community Member
    [SOLVED ] thank you so much Sir... It works.