Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us in NYC Sept 4th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

row count not coming from simple count query in tgreenplum input

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

 

Labels (2)
8 Replies
DataTeam1
Creator
Creator

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

Anonymous
Not applicable
Author

attached screen shot of query ran manually in Green plum


Capture2.PNG
Anonymous
Not applicable
Author

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
Not applicable
Author

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
Champion II
Champion II

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

Anonymous
Not applicable
Author

postinga all screen shots here 

Anonymous
Not applicable
Author

manodwhb
Champion II
Champion II

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