topic Re: row count not coming from simple count query in tgreenplum input in Talend Studio

row count not coming from simple count query in tgreenplum input

Anonymous — Wed, 27 Mar 2019 16:48:59 GMT

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

Re: row count not coming from simple count query in tgreenplum input

DataTeam1 — Wed, 27 Mar 2019 21:54:00 GMT

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

Re: row count not coming from simple count query in tgreenplum input

Anonymous — Thu, 28 Mar 2019 01:13:24 GMT

attached screen shot of query ran manually in Green plum

Capture2.PNG

Re: row count not coming from simple count query in tgreenplum input

Anonymous — Thu, 28 Mar 2019 01:43:20 GMT

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

Re: row count not coming from simple count query in tgreenplum input

Anonymous — Thu, 28 Mar 2019 04:54:14 GMT

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 🙂

Re: row count not coming from simple count query in tgreenplum input

manodwhb — Thu, 28 Mar 2019 04:54:16 GMT

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

Re: row count not coming from simple count query in tgreenplum input

Anonymous — Thu, 28 Mar 2019 09:50:34 GMT

postinga all screen shots here

Re: row count not coming from simple count query in tgreenplum input

Anonymous — Thu, 28 Mar 2019 09:51:22 GMT

posting all screen shot here

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

Re: row count not coming from simple count query in tgreenplum input

manodwhb — Thu, 28 Mar 2019 09:54:21 GMT

@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.