Category Archives: MPP

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.

Posted in Greenplum Database, MPP, Pivotal Database, Pivotal HAWQ, Web External table | Tagged , , , , | Leave a comment

Pivotal HAWQ – MPP database on HDFS

In this post I will go through the architecture of Pivotal HAWQ and how it works. I strongly suggest to go through Introduction to Massively Parallel Processing (MPP) database before reading this as you will need some concepts of MPP … Continue reading

Posted in Big Data, Hadoop, HDFS, MPP, Pivotal HAWQ, Postgress | 7 Comments

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 | 22 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