Greenplum Archives - 2ndQuadrant

How to test Greenplum Community Edition 4.2.1 on VirtualBox

August 10, 2012/2 Comments/in Greenplum /by Marco Nenciarini

As usual Greenplum Community Edition 4.2.1 is available as a VMWare virtual machine based on CentOS with all the fancy tools and the documentation already installed. This allows you to easily try it. This article is an updated guide about running the provided image on VirtualBox.

Greenplum CE 4.2 XML support

July 23, 2012/0 Comments/in Greenplum /by Carlo Ascani

In this article we will see one of the most interesting features added in Greenplum 4.2: XML datatype support.

External web tables in Greenplum

April 10, 2012/0 Comments/in Greenplum /by Carlo Ascani

**External web tables** are one of the most useful features when you you have to load data into a Greenplum database from different sources.

Setting JDBC with Greenplum

January 19, 2012/1 Comment/in Greenplum /by Carlo Ascani

JDBC is the driver used to access a database with Java. Greenplum has a full working JDBC implementation. In this short article we’ll see how to use it.

Greenplum 4.2 is out!

January 2, 2012/0 Comments/in Greenplum /by Carlo Ascani

With an announce on the forum, Greenplum staff has spoke out about the new version of their Database Management System. I can’t resist to blog about some of its new features.

How to initialize Greenplum on multiple nodes

December 16, 2011/0 Comments/in Greenplum /by Carlo Ascani

In the [previous article](https://www.2ndquadrant.com/en/2011/12/a-greenplum-41-handbook.html) we have seen how to install Greenplum on multiple nodes. After installation steps, we must init the entire system. Let’s see how.

A Greenplum 4.1 installation handbook

December 5, 2011/0 Comments/in Greenplum /by Carlo Ascani

One of the main advantages using Greenplum is that it gains power when it uses multiple nodes. Horizontal scalability is a main feature of Greenplum. Here is a compact handbook to install a multi-node Data Warehouse environment with Greenplum.

Using Greenplum 4.1 in Ubuntu 11.10

November 28, 2011/0 Comments/in Greenplum /by Carlo Ascani

Greenplum does not officially support Ubuntu Server 11.10 as underlying operating system. However, I needed to install it on the most recent Ubuntu server just to perform some tests and evaluate it.

Mapreduce in Greenplum 4.1 – 2nd part

November 17, 2011/0 Comments/in Greenplum /by Carlo Ascani

Through this article, we are going to complete the MapReduce job started in the [previous article](https://www.2ndquadrant.com/en/2011/10/mapreduce-in-greenplum.html).

Performing ETL using Kettle with GPFDIST and GPLOAD

November 7, 2011/1 Comment/in Greenplum /by Giulio Calacoci

Scenario: We have a remote datasource, served by a gpfdist server. We need to import the data in a Greenplum database, while performing some ETL manipulation during the import. It is possible to accomplish this goal with a simple transformation in a few steps using Kettle.

2ndQuadrant is now part of EDB