Category Archives: Greenplum Database

Query Greenplum Database from Pivotal HAWQ

I was getting lot of requests on this so I decided to write a separate post. The question was how do I query a Greenplum Database (GPDB) from Pivotal HAWQ. Advertisements

Posted in Greenplum Database, MPP, Pivotal Database, Pivotal HAWQ, Web External table | Tagged , , , , | 1 Comment

Introduction to Massively Parallel Processing (MPP)database

In Massively Parallel Processing (MPP) databases data is partitioned across multiple servers or nodes with each server/node having memory/processors to process data locally. All communication is via a network interconnect — there is no disk-level sharing or contention to be … Continue reading

Posted in Greenplum Database, MPP, Pivotal Database, Postgress | 27 Comments

Greenplum and Hadoop HDFS integration

One of the features of Greenplum 4.2 version is the use of Hadoop HDFS file system to create external tables. This is extremely useful when you want to avoid file movement from HDFS to local folder for data loading. In … Continue reading

Posted in gphdfs, Greenplum Database, Hadoop, HDFS, Postgress | 39 Comments

Installing Greenplum Database: Community Edition on a Mac OS X 10.7

Some of the key features of Greenplum Database are:     Massively Parallel Processing (MPP) Architecture for Loading and Query Processing     Polymorphic Data Storage-MultiStorage/SSD Support     Multi-level Partitioning with Dynamic Partitioning Elimination If you want to test this database on … Continue reading

Posted in Greenplum Database, Mac, MPP | Tagged , , , , , , , | 7 Comments