O'Reilly logo

Getting Started with Greenplum for Big Data Analytics by Sunila Gollapudi

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Using Weka with Greenplum

As saw seen in Chapter 3, Advanced Analytics – Paradigms, Tools, and Techniques, Weka is a Java-based analytics framework and an alternative to R. As it is a Java-based analytics API, it can connect to any database that supports or has a JDBC driver. Weka comes with a support to a wide range of database and in order to connect to Greenplum, we would need to use the DatabaseUtils.props.postgresql properties file and should be extracted to the HOME directory.

To connect to Postgres/Greenplum from Weka, configure the following properties in the DatabaseUtils.props.postgresql properties file:

jdbcDriver = org.postgresql.Driver
jdbcURL= jdbc:postgresql://<<domain>>:<<port>>/<<dbName>>

Weka has an API InstanceQuery that can be ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required