Installing Procedural Languages and Package Extensions for HAWQ
This topic describes how to install procedural language and package extensions in HAWQ.
HAWQ includes support for the following procedural languages:
Some procedural languages, like PL/pgSQL and PL/Python, are embedded within the HAWQ distribution (or within your HAWQ build if you choose to enable them as build options.) To use them, you simply need to register the procedural language in each database where you want to use it. PL/pgSQL is automatically registered in all HAWQ databases.
Other procedural languages, like PL/R, must be downloaded as a package extension and installed using the
gppkg utility. The PL/Java procedural language can also be installed using the
In addition, you can install the following package extensions for use with HAWQ:
Note: If you enable a procedural language or extension in the template1 database, any new database that you create in HAWQ will contain the procedural language. Only use this option if you are absolutely certain you want to enable the procedural language or extension in all new databases.
To install and activate MADLib for use in your HAWQ cluster, download the MADLib package for Pivotal HDB available on the Pivotal Network. Then, follow the instructions on the following Wiki site.