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

Materialize Common Table Expression in Greenplum

Is there a way to force Greenplum PostgreSQL to materialize a subquery in a WITH clause like what MATERIALIZE and INLINE optimizer hints do as below in Oracle? WITH dept_count AS ( SELECT /*+ MATERIALIZE */ deptno, COUNT(*) AS dept_count FROM …
Yang
  • 7,712
  • 9
  • 48
  • 65
0
votes
1 answer

Insert data in a table from a file in PostgreSQL without double quote

I have a file with some data which I need to insert in a table. I am using gpfdist-external table - table to load the file. I am able to load data in table, but my problem is the fields in input file are enclosed with double quotes like "Emp Name"…
user2148036
  • 11
  • 1
  • 5
0
votes
2 answers

Does Greenplum support Kerberos Authentication between its nodes?

I need to "kerberize" our Greenplum cluster. One of the aspects of this is that I should kerberize the interface between the GP master and its Segment Hosts. I have been unable to determine if this is supported or not. I have seen the parameters…
Wanderer
  • 1,583
  • 4
  • 20
  • 36
0
votes
1 answer

How to insert record into GreenPlum Database from Mule?

This question is a variation of How to read CSV file and insert data into PostgreSQL using Mule ESB, Mule Studio. Earlier we had PostgreSQL but now it has been changed to GreenPlum Database. But PostgreSQL has a native support in Mule Studio but not…
priyanka.sarkar
  • 25,766
  • 43
  • 127
  • 173
0
votes
2 answers

SAS Proc SQL to add a constant to a variable

I have a SAS dataset with numeric variables to, from, and weight. Some of the observations have value 0 for weight. I need all the weight values to be positive, so I wish to simply add 1 to all weight values. How can I do that using Proc SQL? I…
synaptik
  • 8,971
  • 16
  • 71
  • 98
0
votes
1 answer

Create millions of records for ActiveRecord test

In Ruby, I have a test that's a subclass of ActiveSupport::TestCase and access a table through an ActiveRecord subclass in a Postgres (actually Greenplum) database. For a particular test I need to populate the table with on the order of a million…
Gordon Seidoh Worley
  • 7,839
  • 6
  • 45
  • 82
0
votes
3 answers

how to access hadoop hdfs with greenplum external table

oue datawarehouse is based on hive,now we need to transform data from hive to greenplum,we want to use external table with gphdfs,but it looks something goes wrong. the table creating script is CREATE EXTERNAL TABLE flow.http_flow_data(like…
moxpeter
  • 1
  • 4
0
votes
1 answer

Postgresql intarray error: undefined symbol: pfree

I'm trying to install Postgresql (8.2.15) additional supplied modules intarray and intagg for my Greenplum database 4.2.1.0. The installation seems successful; I followed the tutorial here and all the files are copied into the…
Yang
  • 7,712
  • 9
  • 48
  • 65
-1
votes
1 answer

How to extract table names and column names from plpgsql

On the same line as the @Dylan Hogg (user:249597) you mentioned the sql-app.infocruncher.com hosted library is there one for plpgsql? Would highly help GP migration tasks. Basically I have the GP function script from which I'd like to get the…
Laszlo Winter
  • 1
-1
votes
4 answers

Still connect 22 ssh port when using gpinitsystem command of Greenplum withing different ssh port of CentOS7

I want to install Greenplum in CentOS7.9 which is changed default ssh port to 10022. I changed 'gpssh-exkeys' script to add '-p 10022' for all of ssh command and add '-P 10022' for all of scp command. And run it is ok. Then I changed…
linhonghui
  • 1
-1
votes
1 answer

Greenplum turn strings into table

Everyone, how does GP turn the strings looking like a dictionary As below into the table with field names and values. I mean how to made it in SQL {"useCoupon":true,"useLevel":false,"usePoints":false,"useActivity" :false}
Jingwen NING
  • 1
-1
votes
1 answer

st_asmvt getting error in Greenplum with postgis extension

I have succefully install the greenplum and postgis extension. when I use the PostGIS function st_asmvtgeom,I am getting the following error: ERROR: Missing libprotobuf-c (lwgeom_out_mvt.c:46)(seg0 slice1 ip:6001 pid=72306)(lwgeom_out_mvt.c:46)
yxzsjayfan
  • 1
-1
votes
1 answer

Datastage job failed netezza to greenplum data load using ODBC Greenplum Wire Protocol driver

Greenplum_Connector_0,0: The following SQL statement failed: INSERT INTO GPCC_TT_20211121154035261_15420_0_XXXXX_TABLE_NAME (COLUMN1,COLUMN2,...) SELECT COLUMN1,COLUMN2,... FROM GPCC_ET_20211121154035417_15420_0. The statement reported the following…
Lawren Alex
  • 110
  • 5
-1
votes
1 answer

GreenPlum DATE_PART function convert into Hive SQL

I am migrating Greenplum to HiveSql but i could not able to find any such below kind of solution in google search. please help me. DATE_PART('minute',ck_2::time - ck_1::time) gap_1_2 please help me , how do we convert above the statement to…
Developer KE
  • 71
  • 1
  • 2
  • 14
-1
votes
2 answers

Why does GPDB not consider the number of segments in cost estimation

No matter what version of the GPDB open source code, the number of segments is not considered in the cost evaluation, and only a simple process is done when returning the explain result to QD and make the result more clear.
AndreLinDontPushMe
  • 3
  • 1
1 2 3
…
53 54