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

Deployment table: rm_mdm_locations

SaschaITPLSaschaITPL Member Posts: 7 Learner III
in Help
Hey, may someone tell me the column names and types of the "rm_mdm_locations" table in his Rapidmine AI Hub Database? I deleted mine, need to create it again i think
Tagged:

Best Answer

  • BalazsBaranyBalazsBarany Administrator, Moderator, Employee-RapidMiner, RapidMiner Certified Analyst, RapidMiner Certified Expert Posts: 955 Unicorn
    Solution Accepted
    Oh, I didn't read your question well. It's a deployment database.

    Here's the table definition:


    CREATE TABLE public.rm_mdm_locations
    (
        name text COLLATE pg_catalog."default",
        id text COLLATE pg_catalog."default" NOT NULL,
        CONSTRAINT rm_mdm_locations_pkey PRIMARY KEY (id)
    )

    In my environment it has one row, the name is the one I entered, the id seems to be a generated unique ID. You might be able to find the ID in one of the other tables if you already have deployed models.

    Next time, have a backup of your database ready before dropping tables! ;-)

    Best regards,

    Balázs

Answers

  • BalazsBaranyBalazsBarany Administrator, Moderator, Employee-RapidMiner, RapidMiner Certified Analyst, RapidMiner Certified Expert Posts: 955 Unicorn
    Hi @SaschaITPL,

    my 9.8.1 AI Hub database doesn't have such a table. 
    Which version are you using? Can you write some other table names that still exist here? 

    Regards,

    Balázs
  • SaschaITPLSaschaITPL Member Posts: 7 Learner III
    thx it worked
Sign In or Register to comment.