Stack Overflow
Stack Overflow

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
0
votes
1 answer

How to tranfer data from Teradata to Greenplum using Python?

I am using Python to establish a connection to greenplum and run codes automatically. For that I am using these drivers ­ psycopg2,­ psycopg2.extensions & psycopg2.extras. I also have to establish a connection to Teradata and run some codes and…
Shravan Kumar Kantha
  • 1
0
votes
1 answer

Install Greenplum DB 4.2.5.2 and 4.2.6.2 within same host (Single Node)

Can I install Greenplum DB 2 versions, version 4.2.5.2 and 4.2.6.2 within same host? Can run simultaneously? Thanks.
autthapone
  • 105
  • 1
  • 1
  • 7
0
votes
0 answers

Gpload is slow when called in a nested function

We have a talend job (generates Java code) that calls gpload via the following way: new Thread() { public void run() { Runtime rt = Runtime.getRuntime(); final Process ps = rt.exec(cmds, envp); } } My problem is that when we…
Balazs Gunics
  • 2,017
  • 2
  • 17
  • 24
0
votes
1 answer

Postgres date-numeric not working in function

Can anyone help me to resolve the issue ?? CREATE OR REPLACE FUNCTION func_maj_get_new_user(in_date numeric) RETURNS integer AS $BODY$ declare count_newusr integer; begin SELECT count(a.app_uid) INTO…
William R
  • 739
  • 2
  • 13
  • 34
0
votes
2 answers

Greenplum to SAS Bulkload gpfdist error - line too long in file

I'm currently doing a bulk load from Greenplum to SAS. Initially there was one field with a backslash "\" at the end of the column causing to throw an error during loading. To resolve it I changed the format from TEXT to CSV and worked fine. But…
mtryingtocode
  • 939
  • 3
  • 13
  • 26
0
votes
1 answer

A gpload control file processing error occurred. Entry must be a YAML sequence

I want to load data into a greenplum database with gpload.py (Windows Server). But I only get a weird output: |ERROR|A gload control file processing error occured. The gpload:input:source(1):file entry must be a YAML sequence I tried to use gpload…
Zündi
  • 1
  • 3
0
votes
1 answer

Unloading Data using Writable External Table

I am trying to create a Writeable External Table in Greenplum (postgresql) and unload data from a Greenplum Table into HDFS using it. Here is the code: CREATE WRITABLE EXTERNAL TABLE test_writable ( LIKE awc_merged.delivery ) LOCATION…
Jones
  • 379
  • 3
  • 9
  • 23
0
votes
1 answer

Releasing the space created by deletion of rows from table on greenplum

I have a table on greenplum from which data is being deleted on a daily basis using a simple delete statement. However, the size of the table is not decreasing. Is there some way using which the space returned by deletion of rows is removed from the…
Nisha Singh
  • 15
  • 2
  • 8
0
votes
2 answers

ERROR: Segment connection failed: allocateWriterGang attempted to return a bad gang. (cdbgang.c:2591)

Using Greenplum database version 3.2.3 on Solaris. Step 1. Create a table. CREATE TABLE ivdb.OPTION_PRICE ( SecurityID integer NOT NULL, Date timestamp NOT NULL, Root char(5) NOT NULL, Suffix char(2) NOT NULL, Strike integer NOT…
caseyboardman
  • 799
  • 2
  • 11
  • 26
0
votes
1 answer

Passing table name to function Dynamically as Input parameter and using it

In the below function I am passing in my table name as text 'K' and wish to use it for cursor declaration inside my function.I am using postgres 8.2 (greenplum) I used quote_ident(k), dint work either. Could some one help me out. THanks! CREATE OR…
user2569524
  • 1,651
  • 7
  • 32
  • 57
0
votes
1 answer

public. does not exist

Say I have a temporary table my_table, and I would like add a column to it that acts as a primary key. I have tried with: ALTER TABLE my_table ADD COLUMN id SERIAL; UPDATE my_table SET id = nextval(pg_get_serial_sequence('my_table','id')); ALTER…
Amelio Vazquez-Reina
  • 91,494
  • 132
  • 359
  • 564
0
votes
0 answers

java.lang. NullPointer Exception (JNICalls.c:70)

I am getting this error when i call this function in postgres /greenplum select pps_functio n.java_aes 256_dec('test'); this is the code import java.io.BufferedReader; import java.io.File; import java.io.FileReader; import…
user3361441
  • 11
  • 1
  • 3
0
votes
0 answers

Concatenate arrays across column in Greenplum

I am trying to aggregate the arrays present in column 'agg' grouping them by product and get the all the events from the last 13 weeks. for example : the first row value of aggregation should be like : aggregate all the arrays grouping them by…
user2569524
  • 1,651
  • 7
  • 32
  • 57
0
votes
1 answer

Cannot execute an anonymous code block with DO in Greenplum

Greenplum Database (a PostgreSQL fork) is throwing an error everytime I try to execute a DO statement like the one below. Specifically, ERROR: syntax error at or near "DO". Why is this? I'm running Greenplum (version?) based on PostgreSQL…
hot_whisky
  • 1,072
  • 1
  • 9
  • 10
0
votes
1 answer

Scheduling a postgreSQL query operating on greenplum DB

I have a table that has to be populated every hour from the data being pulled out of Greenplum.This table is being stored on the Greenplum server. So,what I want to know is that what method(python script, windows scheduler or anything) will be…
Nisha Singh
  • 15
  • 2
  • 8
1 2 3
…
53 54