Top "Greenplum" questions

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

Where clause inside an over clause in postgres

Is it possible to use the where clause inside an overclause as below ? SELECT SUM(amount) OVER(partition by prod_…

sql postgresql partitioning greenplum

Finding mean, standard deviation ,percentiles for all numeric variables in table

I have 30 numeric numeric columns in a table .I want to find mean,std, percentiles for all the columns in …

sql postgresql stored-procedures plpgsql greenplum

Numeric field overflow exception

How I should rewrite my insert statement ? CREATE TABLE test_table ( rate decimal(16,8) ); INSERT INTO test_table VALUES (round(3884.90000000 / 0.00003696, 8)); Exception: …

sqldatatypes greenplum