topic Re: How to set up complex Greenplum Query in Talend? in Talend Studio

How to set up complex Greenplum Query in Talend?

Anonymous — Mon, 25 Sep 2017 23:57:39 GMT

Hello there Talend Community,

I am rather new to Talend and am not sure what the best practice is to design a Talend job that outputs an Excel file from a complex query. I'm hitting about 10 tables with sub queries and from 3 different schemas from a Greenplum DB but I haven't found a simple solution to do so (tmap, multiple tGreenplumInput)

Any guidance or suggestions would greatly help!

Best,

Alex

Re: How to set up complex Greenplum Query in Talend?

Anonymous — Fri, 29 Sep 2017 07:13:51 GMT

Hello,

What does your complex Greenplum query look like? Could you please set an example for us?

Best regards

Sabrina

Re: How to set up complex Greenplum Query in Talend?

Anonymous — Mon, 02 Oct 2017 23:31:28 GMT

I actually was able to fix the query (removed dashes, notes and aliases with quotes) and am using a Postgresql Input component now but have a "java.lang.ClassNotFoundException: org.post.gresqlDriver" error. I believe I have the proper modules installed (see attached) so I'm not sure what the exact issue is.

TalendError.JPG