Top "Greenplum" questions

Greenplum is the worlds first open-source massively parallel processing database based on PostgreSQL.

NOT EXISTS clause in Postgresql

Anyone knows how to perform such query in Postgresql? SELECT * FROM tabA WHERE NOT EXISTS ( SELECT * FROM tabB WHERE tabB.…

postgresql greenplum
Advantages of databases like Greenplum or Vertica compared to MongoDB or Cassandra

I am currently working in a few projects with MongoDB and Apache Cassandra respectively. I am also using Solr a …

mongodb cassandra data-warehouse vertica greenplum
20 Billion Rows/Month - Hbase / Hive / Greenplum / What?

I'd like to use your wisdom for picking up the right solution for a data-warehouse system. Here are some details …

database mapreduce data-warehouse greenplum vldb
Greenplum vs PostgreSQL

What are the arguments for and against using Greenplum instead of PostgreSQL in a webapp (django) environment? My gut reaction …

sql database django postgresql greenplum
How to use a SQL window function to calculate a percentage of an aggregate

I need to calculate percentages of various dimensions in a table. I'd like to simplify things by using window functions …

sql postgresql aggregate-functions window-functions greenplum
DISTRIBUTE BY notices in Greenplum

Say I run the following query on psql: > select a.c1, b.c2 into temp_table from db.A …

sql greenplum