[resolved] How to Get Row count from Hive Table

[Anonymous]

Hi I am very new to Talend BIG Data and developing Archiving job, so i have to do reconciliation of source file records with archive tables. can any one suggest me how get the row count? 
I may not know if table is exist or not. 

[Anonymous]

Hi umeshrakhe,

Thanks for posting that you resolved it by yourself. Could you please share your solution with us?

Best regards
Sabrina

[Anonymous · Accepted solution]

I have resolve this problem using below two modifications. 

I used tHiveInput instead tHiveRow. 
And pass "Select count(*) from"+context.TableName.