Greenplum CE 4.2 XML support
In this article we will see one of the most interesting features added in Greenplum 4.2: XML datatype support.
Carlo Ascani is a PostgreSQL enthusiast and contributes regularly to 2ndQuadrant blog.
In this article we will see one of the most interesting features added in Greenplum 4.2: XML datatype support.
**External web tables** are one of the most useful features when you you have to load data into a Greenplum database from different sources.
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.
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.
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.
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.
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.
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).
Mapreduce is a very trendy software framework. It has been introduced by Google (TM) in 2004. It is a large topic, and it is not possible to cover all of its aspetcs in a single blog article. This is a simple introduction to the _mapreduce_ usage in Greenplum 4.1.
In this article, I am going to upgrade a Greenplum cluster from version 4.0 to 4.1 using `gpmigrator`. `gpmigrator` is an utility shipped with Greenplum Community Edition whose purpose is to perform a live upgrade of an existing database.