How do I resolve the error "Execution of 'Decision Tree Classification (CART)' failed. Error details: MADlib version 1.7 or higher must be installed on target database."

[Tojo James]

I have been trying to use the decision tree (MADlib) operator in Team Studio but the following error shows up. "Execution of 'Decision Tree Classification (CART)' failed. Error details: MADlib version 1.7 or higher must be installed on target database". The same error shows up when I am using any operator associated with MADlib. Is there a way to solve this issue Can I upgrade MADlib version on my system

[Noora Husseini]

Hi Tojo,

That particular version of Decision Tree operator "Decision Tree Classification (CART)" runs on a PostgreSQL database and requires some special functions to be installed in the database. If you can only access the data through PostgreSQL then you will need to install them.

If the data location is flexible, you can use a Hadoop data source instead. You should then be able to use the Decision Tree operator with no error.

Thanks,

Noora

[Jeremy Melville]

As Noora was mentioning, here are the instructions for installing the Stored Procedures needed on your PostreSQL database:https://docs.tibco.com/pub/sfire-dsc/6.5.0/doc/html/TIB_sfire-dsc_6.5.0_...