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

why greenplum can not create same table name in different schema

I want create same external table in greenplum in different schema ,but it turns out ERROR: relation "my_external_table_name" already exists click check the picture: this is before create external table click check the picture: this is after create…
Rocke
  • 1
  • 2
-1
votes
1 answer

How to stop entry in GREENPLUM log_alert_* tables?

I am using Pivotal Greenplum sandbox. Want to stop entry into log_alert_* tables? Which are under gpperfmon database. Is, there is a way to stop it? Any help will be appreciated.
Pra
  • 31
  • 6
-1
votes
1 answer

max_statement_mem work fault in Greenplum 4.2

how could this happened?,the set 8GB didnt work?
user5107182
  • 21
  • 5
-1
votes
1 answer

is Greenplum is compatible with IPV6 Address

I just want to know whether greenplum supports IPV6 or not.. Will anyone help, that how and which version of Greenplum Supports IPV6 ? One of my client worried, As per DOT and TRAI compliance requirement, all the application should support IPV6. As…
Gurupreet Singh Bhatia
  • 708
  • 6
  • 17
-1
votes
1 answer

creating compressed table which is appendable in Greenplum Database

I have a few tables created with the following compression logic CREATE TABLE xyz ( DATE_HOUR TIMESTAMP, MV CHARACTER VARYING (255), VISITS NUMERIC ) WITH (APPENDONLY = true, COMPRESSLEVEL = 1, ORIENTATION = column, COMPRESSTYPE =…
Nisha Singh
  • 15
  • 2
  • 8
-1
votes
3 answers

Parallel Data Loading in Greenplum

Greenplum says that it has parallel data loading. I have a doubt regarding how it works. Please do explain it to me. I understand that records are read in parallel but I can't understand how parallel writes are done. Is the parallel writes done on…
navin
  • 384
  • 2
  • 4
  • 15
-1
votes
1 answer

Convert hex to utf8 in greenplum in regexp_replace

I have strings in a table that contain hex values such as \ffffffc4. An example is the following: Urz\ffffffc4\ffffff85dzenie zgodne ze standardem High Definition Audio The following code can convert the hex into UTF8: select chr(x'c4'::int)…
apostolos1975
  • 13
  • 3
-2
votes
1 answer

Our GCP docker instance is up and running but then we are unable to connect to the GreenPlum

Our GCP docker instance is up and running but we are unable to connect to the GreenPlum and it is giving the Connection to xx.xxx.xxx.xx:5432 refused. Check that the hostname and port are correct and that the postmaster is accepting TCP/IP…
Srikar Manthatti
  • 504
  • 2
  • 15
-2
votes
1 answer

I need parse JSON to Greenplum

How to parse JSON { "35673": [ "234", "357", "123" ], "34566": [ "333", "456", "789" ] } to Greenplum table, format 1 key 1 value?
Chainik_1
  • 1
-2
votes
2 answers

Return table listing distinct values in each column

I am familiarizing myself with a data table that has numerous columns for descriptions of individuals' job roles. I would like to return a table that lists in each column the distinct values present in the table for each column. I understand how to…
jmabs
  • 97
  • 2
-2
votes
1 answer

Kettle gpload failed ERROR: permission denied: no privilege to create a readable gpfdist(s) external table

When using kettle greenplum bulkloader and ERROR: permission denied: no privilege to create a readable gpfdist(s) external tableenter image description here
Galen
  • 5
  • 4
-2
votes
2 answers

Unable to install postgis extenstion with greenplum

I have installed greenplum4.3.1.9 on rhel7 server, but i am not able to install postgis extension with greenplum. please help. While i am installing postgis extension using gppkg package, i am getting following error: -bash-4.2$ gppkg -i…
Sachin Kr. Saini
  • 33
  • 1
  • 7
-2
votes
3 answers

SQL query error (correlated subquery with skip-level correlations is not supported )

I have a following sql query which run at: PostgreSQL 9.5.1, compiled by Visual C++ build 1800, 64-bit but not at: PostgreSQL 8.2.15 (Greenplum Database 4.3.5.4 build 1) on x86_64-unknown-linux-gnu, compiled by GCC gcc (GCC) 4.4.2 SELECT id, (SELECT…
ivankiss
  • 31
  • 7
-2
votes
1 answer

How do We Transform sql server 2012 query syntax into postgresql or standard sql

We tried to transposing of data using unpivot operator in sql server 2012.same thing we have to output using postgres database. so,we have to rewrite given syntax into postgresql. We have also tried on postgresql : uncrosstab() function using given…
NEO
  • 389
  • 8
  • 31
-3
votes
1 answer

How to specify subquery in the option "dbtable" in Spark-jdbc application while reading data from a table on Greenplum?

I am trying to read data from a table on Greenplum into HDFS using Spark. I gave a subquery in options to read the greenplum table as below. val execQuery = s"(select ${allColumns}, 0 as ${flagCol} from dbanscience.xx_lines where year=2017 and…
Torque
  • 99
  • 3
  • 16
1 2 3
…
53
54