row count not coming from simple count query in tgreenplum input

[Anonymous]

My requirement is very simple 

compare row count in source and row count in target 

below is how I am doing it.

1. get the count from source . I am using toracle input fetches me row count in file like 

src_count

1111

2. get the row count in target .  I am using toracle input fetches does not fetch the row count .

i am getting file as :

tgt_count

3. checked manually there will be some number . But the tgreenplum does not fetch me any thing

Please help , review the attached image as well. schema i have double checked i am using int(data type) only

oracle is fine ..only greenplum is problem

[DataTeam1]

Are you sure that syntax in greenplum? Did you try select count(*) in greenplum directly?

[Anonymous]

attached screen shot of query ran manually in Green plum

Capture2.PNG

[Anonymous]

I tried to get count by using a tlogrow , but again it does not work . Only for greenplum ..Very weird tool .

Can some one help

Capture3.PNG

[Anonymous]

Hi @rahul998000 

Could you please raise a support ticket if you are using a Subscription product? If you are using a open source platform, could you please raise a JIRA ticket for this issue?

https://jira.talendforge.org

It could be something minor. Since I do not have Greenplum handy, I could not check it myself. 

Warm Regards,
Nikhil Thampi

Please appreciate our Talend community members by giving Kudos for sharing their time for your query. If your query is answered, please mark the topic as resolved 🙂

[manodwhb]

@rahul998000 ,can you show me the tGeenplumnInput component settings including schema?

[Anonymous]

postinga all screen shots here 

[Anonymous]

posting all screen shot here

Capture8.PNG
Capture7.PNG
Capture6.PNG
Capture5.PNG

[manodwhb]

@rahul998000 ,if you run the same query was giving output in the outside of talend? if cna you change the datatype from long to Int in tDBInput schema.