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

Greenplum : Object Creation Date

I have used pg_stat_operations to know when a table or view is created or altered, I want to know when a function or sequence is created or modified. (Function list is availed at pg_proc and information_schema.routines but there is no option for…
Gurupreet Singh Bhatia
  • 708
  • 6
  • 17
0
votes
1 answer

Greenplum/Postgres 8 function dynamic result set?

I need to write a function that returns a table with unknown number of columns. If i receive 'None' in column input parameter then that column shouldn't be included in the output. In postgres 9+ there is a solution for this problem. something like…
clairvoyant
  • 195
  • 1
  • 11
0
votes
0 answers

How to read PostgreSQL refcursor in SSRS

I am trying to have an SSRS dataset read from a PostgreSQL function which returns a refcursor (using Pivotal Greenplum) but I'm having terrible luck with it. I've tried fetching from it, but to no avail. I've tried using the way you would do it…
Patrick J
  • 1
0
votes
2 answers

proper stop Greenplum when on one node ssh is down

Having problems with greenplum DB. One one node that sshd went down and we can not connect to that node. Only hard reboot is possible. We try to proper stop greenplum so we want to be able start it again. In GP docs there is no description how to…
martinnovoty
  • 896
  • 8
  • 17
0
votes
1 answer

How to write a function using arrays as input parameter in postgres 8.2

I am fairly new to Postgres and would like help with writing function that has an array as input parameter. I am using the function for a SSRS report and would like to add multiselect functionality CREATE OR REPLACE FUNCTION foo(facid bigint,…
katie
  • 23
  • 5
0
votes
1 answer

Drop or truncate sub-partitions in Greenplum

How to drop or truncate sub-partitions in Greenplum? I am unable to find any syntax that can drop a sub-partition (for a specific partition specifically) from a table. Thanks.
Deepak
  • 53
  • 1
  • 7
0
votes
1 answer

Truncate partition based on condition

I need to truncate a partition in Greenplum based on a condition. What would be the easiest possible way to achieve that? Example: ALTER TABLE PACKAGE_INFO TRUNCATE PARTITION FOR ('BOX'); I need to truncate the partition with value - BOX in the…
Deepak
  • 53
  • 1
  • 7
0
votes
3 answers

Issue of Regular Expression for URL pattern on POSTGRES

select regexp_replace('https://www.facebook.com/cricket/hello', '.*\..*?\/', '') The above code is giving me hello instead of cricket/hello I checked on Regexp checking website and the pattern is correct. I am not sure where am I going…
Ashish
  • 131
  • 9
0
votes
2 answers

Is there a way to define replacement of one string to other in external table creation in greenplum.?

I need to create external table for a hdfs location. The data is having null instead of empty space for few fields. If the field length is less than 4 for such fields, it is throwing error when selecting data. Is there a way to define replacement of…
Srini
  • 3,334
  • 6
  • 29
  • 64
0
votes
1 answer

Not able to get currval or lastval of a sequence in a query in greenplum which uses postgresql 8.3

I am trying to solve the issue in a query without writing a function. I have a table which has user information as below: user_id user_name user_phone_number user_location created_at 1 abc 123 X 2014-01-01 1 …
preetham nadella
  • 1
  • 1
0
votes
3 answers

Greenplum login issue

We have different user in our environment(Greenplum/ Version 4.2.x) (1. dbauser - User having DBA rights, can create objects and grant accss to other users etluser - User having DML access and perform DMLs through Informatica analyticsuser - having…
Gurupreet Singh Bhatia
  • 708
  • 6
  • 17
0
votes
1 answer

Multi-column partitioning in Greenplum

I am trying to do multi-column partitioning in Greenplum database using PostgreSQL. However I keep getting an error - ERROR: partition key has 2 columns but 1 columns specified in VALUES clause LINE 15: VALUES ('10001','2014-03-11'), …
Deepak
  • 53
  • 1
  • 7
0
votes
0 answers

is Recursive query supported in Greenplum

There is one query in oracle which is using CONNECT BY, my requirement is i need to migrate it to Greenplum Sql I found n tried with recursive class, but getting below error ********** Error ********** ERROR: RECURSIVE option in WITH clause is…
Gurupreet Singh Bhatia
  • 708
  • 6
  • 17
0
votes
2 answers

Passing parameters gives array error in Postgres 8.2 function

I've got this function /* @Function: valiDates [Avoid inserting data from invalid dates] @Purpose: Providing a _TABLE and a date _COLUMN to be validated. Given a _DATE (from script name) validate that a certain % of data (_TOLERANCE) belongs to the…
Julian Larralde
  • 9
  • 2
0
votes
1 answer

Merge multiple tables with a common column name

I am trying to merge multiple tables that have a common column name which need not have the same values across the tables. For ex, -tmp1- id dat 1 234 2 432 3 412 -tmp2- id nom 1 jim 2 3 ryan 4 …
Julio47
  • 37
  • 1
  • 7
1 2 3
…
53 54