Jacque Istok

Posted an answer
Greenplum Vmem protect limit Sandbox

can you explain why you think it didn't work?

2018-02-24 5
Posted an answer
greenplum expand error:port 33001 is used mutiple times on host sdw4

I think we might need a little more info here - can you post the hostnames, ip addresses, and the contents of "select * from gp_segment_configuration" ?

2018-02-24 5
Posted an answer
Can UDF be parallel computing?

the short answer is yes. the longer answer is what do you mean you operate on the master node? When you run an SQL statement from the master, it operates in parallel always. So does a UDF. do you want...

2018-01-16 5
Posted an answer
DISTRIBUTED randomly useless

im not sure I completely understand the statement - distributions are how we define where in the cluster the data goes. when it's random, it will go to 1 of the segments and generally keep all the segments...

2018-01-02 5
Commented on a post

Hi wen - this is a longer topic but the short answer is yes, but it's all in how you architect. You can easily implement procedural SQL or python/perl/java to help populate your reporting tables as well...

2018-01-02 2
Posted an answer
Unabale to set statement_mem

im not 100% sure but I would try setting the max_staement_mem and restarting the cluster. then set statement_mem.

2018-01-02 5
Posted an answer
Data Analytics on top of GreenPlum

greenplum will work out of the box with any BI tool, most often I see tableau, MicroStrategy, cognos, power bi, etc. anything that your end users are comfortable with and that you have today will work...

2018-01-02 5
Answer was selected as best
2017-12-27 10
Posted an answer
external table retain data where?

I like to think of the external tables similar to a unix pipe. Data is streamed from the source to one or more segments whether it's a lot or a little and then something can be done with it (insert to...

2017-12-21 5
Posted an answer
is the dimensional data model best suited for the GreenPlum?

it's a pretty varied answer. generally speaking, I personally prefer a dimensional model over something more snowflake'd out because I think it's easier for our users to understand. it also necessitates...

2017-12-04 5
Posted an answer
Testing Open Source GPDB for production deployment

binaries are planned to be available shortly for greenplum v5.2 and above.

2017-11-17 5
Posted an answer
Can Greenplum take advantage of GPU?

there does exist examples where gpu's can be leveraged via language extensions (like python). so the short answer is yes.

2017-11-17 5
Posted an answer
Does Greenplum support spatial objects?

the short answer is yes. the longer answer is, can you give me more information..? 🙂

2017-11-17 5
Posted an answer
Sandbox: no supported authentication methods available

hi - psql should be located in the bin directory of the greenplum installation directory (probably /opt/greenplum or /usr/local/greenplum). it's been a while, but there should also be a pgadmin gui included...

2017-11-17 5
Posted an answer
Sizng Greenplum

Hi - sizing is a bit more complicated than just a spreadsheet. Everything from concurrency, to types of queries, to amount of data storage, to type of datatypes can affect this. I'd suggest starting...

2017-09-21 5
Posted an answer
the problem of inserting data after creating or truncating a table

im a little confused by the question - are you saying that the first load to a table takes longer than subsequent loads? how are you inserting the data?

2017-09-09 5
Asked a question
I'm interested hearing about Greenplum clusters in use. What kinds of hardware? How many nodes? How much data?

As the community around Greenplum continues to grow, I'm interested in hearing from real users what their clusters look like? How big? What kind of hardware? How many segments per host? How much data?...

2017-09-06 2
Posted an answer
How is Greenplum So Fast?

Hi Joe - Greenplum is essentially an auto-magically sharded implementation of Postgres, which allows your data to be spread among many Postgres instances (segments) and have them all work in parallel to...

2017-09-05 5
Posted an answer
jdbc driver for greenplum

Greenplum is based off of Postgres, therefore you can use standard Postgres urls for jdbc: To connect to using JDBC, you have to use a connection URL. It can be in one of these three forms: * jdbc:postgresql:databasename...

2017-08-30 5
Posted an answer
Is Greenplum cloud capable or not?

Greenplum most certainly is cloud capable and you can see that by going to either the Amazon AWS Marketplace https://aws.amazon.com/marketplace/pp/B073V7NWQD?qid=1504042571836&sr=0-1&ref_=srh_res_product_title...

2017-08-29 5