Skip to main content

Qlik

cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Announcements
Join us at Qlik Connect for 3 magical days of learning, networking,and inspiration! REGISTER TODAY and save!
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable
‎2017-09-25 07:57 PM

How to set up complex Greenplum Query in Talend?

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

Labels (2)
Labels
79 Views
0 Likes
2 Replies
Anonymous
Not applicable
‎2017-09-29 03:13 AM
Author

Hello,

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

Best regards

Sabrina

79 Views
0 Likes
Anonymous
Not applicable
‎2017-10-02 07:31 PM
Author

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
79 Views
0 Likes