Employee DisclaimerThe opinions and interests expressed on this blogs are the employees' own and do not necessarily represent employer's positions, strategies or views. Employer makes no representation or warranties about employee blogs or the accuracy or reliability of such blogs. When you access employee blogs, even though they may contain the Employer logo and content regarding Employer products and services, employee blogs are independent of Employer and Employer does not control their content or operation. In addition, a link to a blog does not mean that Employer endorses that blog or has responsibility for its content or use. This disclaimer was put into place on 11th November, 2013
Author Archives: Diwakar Kasibhotla
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.
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
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
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
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
Last week I came across an interesting problem. Problem: I want to centralize my average assets calculation in one place and different downstream systems should be able to consume it. For example: Cognos reports should be able to use this, … Continue reading
Here is a presentation by Robert Dawson that he did at OOW 2011. Interesting on how he correlated Exadata adoption with Grief Cycle. These are roadblocks that nobody wants to talk about but every organization implementing Exadata will face them.