The Altair Community is migrating to a new platform to provide a better experience for you. In preparation for the migration, the Altair Community is on read-only mode from October 28 - November 6, 2024. Technical support via cases will continue to work as is. For any urgent requests from Students/Faculty members, please submit the form linked here

Is there anyway to view the generated schema from Write Database?

yakitoyakito Member Posts: 22 Contributor II
edited November 2018 in Help
Hello,

Every time I try to use the "Write Database" (MySQL) operator I get the following error: "Can't create table xxxx. error numer 139"

I tried to use the same operator with a different set of data and it worked fine, so I am assuming that there is some issue with the data of set 1. Maybe some character encoding error or similar.

Is there anyway to view the schema that the Write Database operator is using in order to analyze and maybe correct the error?

Any other workaround for this issue?

Thanks!

Answers

  • MariusHelfMariusHelf RapidMiner Certified Expert, Member Posts: 1,869 Unicorn
    Hi,

    you should see the SQL statements produced by the operator in RapidMiner's log view.

    Best,
    Marius
  • yakitoyakito Member Posts: 22 Contributor II
    Hello Marius!
    Thanks for your time. I do see the SQL statement for the SELECT query but not for the one which creates the table. I should be able to see that one too?

    This is an example of what I am getting

    Feb 29, 2012 3:43:13 PM SEVERE: Process failed: Database error occurred: Can't create table 'db.ppredict' (errno: 139)

    Thanks again!

    PS: I did sole the issue using the "Select Attribute" operator and filtering some columns, but now the best solution.
Sign In or Register to comment.