Archive | GreenPlum MPP

Parse pg_dump Functions and Views Into Their Own Files (GreenPlum / Postgres)

Here's what we wanted: Each function from our GreenPlum (aka Postgres) database scripted out into it's own file. I think after much hacking I've got something working that only requires a small amount of manual intervention. For whatever reason PostgreSQL/GreenPlum doesn't seem to have a native way to split objects into separate files. This functionality is […]

GreenPlum and DBFit

Just a quick little stub of a post to track progress using the DBFit Test Driven Database Development Tool with our GreenPlum installation. DBFit seemed like a great option since it will theoretically support both GreenPlum and SQL Server.   I ran through the getting started documentation on the DBFit site fairly quickly and had the initial […]

SQL Server T-SQL To GreenPlum PostgreSQL Syntax Cheat Sheet

Here's a quick translation from SQL Server's T-SQL to Pivotal's MPP GreenPlum PostgreSQL for some of the most commonly used syntax (i.e. here's the stuff I've tripped over while moving from SQL to GreenPlum/Postgres) .   SQL Server - TOP SELECT TOP 100 * FROM MyTable Corresponding PostgreSQL - LIMIT SELECT * FROM my_table LIMIT […]

GreenPlum MPP Tool Review: Navicat For Postgres

I've spent a few hours so far working with Navicat for Postgres connected to our GreenPlum MPP (Massively Parallel Processing Database). (pgAdmin continues to iritate me but it'll be hard for a competitor to supplant the free incumbent). There is definitely some solid functionality here. Pros: Performance - The UI seems to be balzingly fast […]

SQL Server To GreenPlum MPP/Postgres Transition

I'm working with a team building a data warehouse using Pivotal's GreenPlum MPP (Massively Parallel Processing) database which is based on PostgreSQL. Although, all the data modeling basics transition easily from RDBMS to RDBMS there's a bit of a learning curve switching tools and syntax. Listed below are some of the items I've noted during the […]

SSIS Export To UTF-8 or UNIX (or how to set your code page to output a flat file for unix)

As more and more companies are moving to heterogenous environments with both windows and unix systems the life of the Microsoft SQL Server developer is becoming much more interesting. For our recent data warehouse project I was asked to create a SQL Server 2012 Integration Services (SSIS) ETL package to output a text file for […]