Questions tagged [greenplum]

Greenplum is the worlds first open-source massively parallel processing database based on PostgreSQL.It provides powerful and rapid analytics on petabyte scale data volumes. Uniquely geared toward big data analytics, Greenplum Database is powered by the world’s most advanced cost-based query optimizer delivering high analytical query performance on large data volumes.

Greenplum is a massively parallel processing database based on PostgreSQL and is designed for analytic data warehouses to manage, store and analyze terabytes to petabytes of data. Greenplum is developed by Pivotal.

797 questions
4
votes
2 answers

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 table.I don't want to write all the column names manually like below select date, avg(col1), stddev(col1), avg(col2), stddev(col2),…
user8545255
  • 761
  • 3
  • 9
  • 21
4
votes
2 answers

Replace all characters except ascii 32 to 127 and ascii 0, 13, 27 in postgres sql

Is there any function which can replace all characters except ascii 32 to 127 and ascii 0, 13, 27 in postgres sql. I do not want to replace spaces, line feeds etc. I want to replace weird characters like club signs, square or a weird asterisk. I…
Nik
  • 371
  • 4
  • 15
4
votes
2 answers

Using Greenplum with Spring

Do any of the Spring projects provide a template or utility for inserting into or working with Greenplum? I understand that one approach is, using Spring Batch, to have a tasklet call the Greenplum gpload utility which will then insert a specified…
user1052610
  • 4,440
  • 13
  • 50
  • 101
3
votes
2 answers

How to update a column based on values of other columns

I have a tables as below row_wid id code sub_code item_nbr orc_cnt part_cnt variance reporting_date var_start_date 1 1 ABC PQR 23AB 0 1 1 11-10-2019 NULL 2 1 ABC PQR 23AB 0 1 1 …
rach
  • 33
  • 3
3
votes
1 answer

How i can insert data from dataframe(in python) to greenplum table?

Problem Statement: I have multiple csv files. I am cleaning them using python and inserting them to SQL server using bcp. Now I want to insert that into Greenplum instead of SQL Server. Please suggest a way to bulk insert into greenplum table…
3
votes
1 answer

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: ERROR: numeric field overflow SQL state: 22003 Detail: A field with…
DaysLikeThis
  • 133
  • 1
  • 1
  • 5
3
votes
1 answer

how to convert base64 string to bytea in postgresql8.2

I need to convert base64 string to bytea type. But when I Executed SQL statements by the pgAdminIII: select decode("ygAAA", 'base64'); I got the following error message: ERROR: syntax error at or near ")" LINE 1: select decode('ygAAA', 'base64'); …
yelan_fn
  • 41
  • 1
  • 3
3
votes
0 answers

Greenplum Django migrate distribution key error

I am currently working on a Greenplum project. Part of this project is creating a simple webapp for the visualization and statistics of data. When I tried integrating Greenplum with Django it failed, giving me the following error: python manage.py…
pandalex
  • 31
  • 1
3
votes
2 answers

GNU Parallel | pipe command

I am completely new in using GNU parallel and I need your advice in running the command below using GNU parallel: /home/admin/Gfinal/decoder/decdr.pl --gh --w14b /data/tmp/KRX12/a.bin | perl /home/admin/decout/decoder/flow.pl >>…
Helmy
  • 115
  • 1
  • 3
  • 10
3
votes
4 answers

Convert one column to multiple columns in postgres

I have a table like this below : Would like to change the format as below on postgres : I tried to use the case statement but did not give me desired results. Thank you in advance for the help ! EDIT select (case when column_1='A' then column_1…
Vinay
  • 237
  • 2
  • 8
  • 17
3
votes
1 answer

Error at prompt:Setting Up Greenplum command center web Application with centos 6.5

We have small gpdb cluster . In that,We are trying to setup the Greenplum command center web portal. ENVIRONMENT IS Product | Version Pivotal Greenplum (GPDB) 4.3.x Pivotal Greenplum Command Center (GPCC) 2.2 stage of error is : Set up the…
NEO
  • 389
  • 8
  • 31
3
votes
1 answer

When should I use Greenplum Database versus HAWQ?

We are having use case for retail industry data. We are into making of EDW. We are currently doing reporting from HAWQ.But We wanted to shift our MPP database from Hawq into Greenplum. Basically,We would like to make changes into current data…
NEO
  • 389
  • 8
  • 31
3
votes
2 answers

How do I access record elements in postgresql?

PostgreSQL v8.2 (Greenplum) CREATE OR REPLACE FUNCTION util.retrec(OUT p1 date, OUT p2 boolean) RETURNS RECORD AS $BODY$ DECLARE BEGIN p1 := current_date; p2 := true; RETURN; END; $BODY$ LANGUAGE plpgsql VOLATILE; SELECT util.retrec(); This…
PhilHibbs
  • 859
  • 1
  • 13
  • 30
3
votes
2 answers

Greenplum, Pivotal HD + Spark, or HAWQ for TBs of Structured Data?

I have TBs of structured data in a Greenplum DB. I need to run what is essentially a MapReduce job on my data. I found myself reimplementing at least the features of MapReduce just so that this data would fit in memory (in a streaming fashion). …
BAR
  • 15,909
  • 27
  • 97
  • 185
3
votes
1 answer

generate_series for Min and Max dates

Here's the very basic query that i want to accomplish in Greenplum Database (like postgresql 8.2.15). The field create_date in table t is timestamp w/o time zone. Could anyone point me to right query to accomplish this? Thanks. select * from…
Nemo
  • 1,111
  • 6
  • 28
  • 45
1
2
3
53 54