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
0 answers

array_agg_transfn called in non-aggregate context postgres

I have a week_value column from the table "vin_temp_table" with the following values.I am using Greenplum database with postgres 8.2 on it. 633 423 389 348 341 326 321 316 301 293 291 1 2 Now I am trying to aggregate the next 13 values from the…
user2569524
  • 1,651
  • 7
  • 32
  • 57
0
votes
0 answers

syntax error at or near "$1" in postgres

I am trying to run the following function and I get the error "syntax error at or near "$1" Could someone help me out fix this. Thanks! CREATE OR REPLACE FUNCTION vin_calc() RETURNS text AS $BODY$ DECLARE r res%rowtype; i integer default 0; …
user2569524
  • 1,651
  • 7
  • 32
  • 57
0
votes
1 answer

Is SSL communication with Greenplum database server different from normal SSL communication with a typical web server?

While enabling ssl in greenplum, it needs ONLY server.key(which is a private key) & certificates to be present in the master data directory. What about public key and the session key? Why don't we need to provide these keys as well. If we don't…
Prashanth Peddabbu
  • 92
  • 1
  • 1
  • 11
0
votes
1 answer

Greenplum loading data from table to file using external table

I ran the below create script and it created the table:- Create writable external table FLTR (like dbname.FLTR) LOCATION ('gpfdist://172.90.38.190:8081/fltr.out') FORMAT 'CSV' (DELIMITER ',' NULL '') DISTRIBUTED BY (fltr_key); But when I tried…
user3138134
  • 1
  • 1
0
votes
0 answers

Greenplum (Pg 8.2 based) -- Function that performs 3 statements

I'm using Greenplum and I just want to create a function that performs 1 truncate and 2 selects. This is what I have but it is not working CREATE OR REPLACE FUNCTION public.pe_GP3() RETURNS void LANGUAGE plpgsql AS $function$ Begin truncate…
precose
  • 614
  • 1
  • 13
  • 36
0
votes
1 answer

Can any one explain Netezza Disadvantages?

While i am going through the Netezza OLAP appliance , i could see Netezza dynamic scaling is not possible, can anyone please explain this ?
William R
  • 739
  • 2
  • 13
  • 34
0
votes
2 answers

Greenplum - external tables

I have a set of tab delimited files located on a server location and I have created a meta data table and an external table with the same layout as the metadata table. I wanted to know when I run the external table script in PgAdmin 3 is it…
jason
  • 1
  • 1
  • 2
0
votes
2 answers

How do we build Normalized table from DeNormalized text file one?

How do we build Normalized table from DeNormalized text file one? Thanks for your replies/time. We need to build a Normalized DB Table from DeNormalized text file. We explored couple of options such as unix shell , and PostgreSQL etc. I am looking…
user2647763 - RIMD
  • 74
  • 1
  • 11
0
votes
1 answer

products that produced 50% of annual profit/revenue in the last year

ProductName Profit DellVostro--------15714 Nokia510---------13392 SonyE151----------10506 LGE15-------------10326 Nokia20------------8830 samsung1516--------7910 samsung1556-----7560 samsung1517-----7430 fordgt49--------7410 samsung…
user3071665
  • 5
  • 4
0
votes
1 answer

store pig output into greenplum database

How do I store my pig output into greenplum database? I had tried STORE relation INTO 'table' USING org.apache.pig.piggybank.storage.DBStorage('DriverName', 'jdbc:postgresql://host/db', 'id', 'password', 'INSERT INTO table…
sravani malla
  • 47
  • 2
  • 7
0
votes
1 answer

Greenplum anonymous code block error?

We have a schema in Greenplum with Postgres version 8.2, where we are not allowed to create a function. We have some working functions in another server/schema. We like to run those functions in a new schema as anonymous code block. We tried the…
user2647763 - RIMD
  • 74
  • 1
  • 11
0
votes
2 answers

connecting form R (client) to Greenplum server

I'm trying to retrieve data from greenplum cluster into R (win client). I've tried: library("RODBC") conn <- odbcDriverConnect("DSN_name") Sql <- "select * from DB.st.country" cen_data <- sqlQuery(conn,Sql) print(cen_data) I'm getting error: 0A000…
dan
  • 15
  • 1
  • 6
0
votes
1 answer

Transfer data from an ORACLE View to greenplum DB table

I have an Oracle view containing very large amount of data in it and I want to migrate this data in a table in Greenplum database. Is there any way I can write any query in Postgresql to fetch that Oracle view's data? If not possible by query in…
user2148036
  • 11
  • 1
  • 5
0
votes
0 answers

Handling newline character in Greenplum external table

I am creating Greenplum external table and populating it with data from my map reduce output files present in hdfs. I am able to connect external table to the HDFS and access all the files present in those directories. All files have values in comma…
user1188611
  • 945
  • 2
  • 14
  • 38
0
votes
1 answer

Most effective way to push data from a SQL Server database into a Greenplum database?

Greenplum Database version: PostgreSQL 8.2.15 (Greenplum Database 4.2.3.0 build 1) SQL Server Database version: Microsoft SQL Server 2008 R2 (SP1) Our current approach: 1) Export each table to a flat file from SQL Server 2) Load the data into…
Jon Jaussi
  • 1,298
  • 3
  • 18
  • 36
1 2 3
…
53 54