[resolved] How to Get Row count from Hive Table

Five Stars

[resolved] How to Get Row count from Hive Table

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. 

Accepted Solutions
Five Stars

Re: [resolved] How to Get Row count from Hive Table

I have resolve this problem using below two modifications. 

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

All Replies
Moderator

Re: [resolved] How to Get Row count from Hive Table

Hi umeshrakhe,

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

Best regards
Sabrina
--
Don't forget to give kudos when a reply is helpful and click Accept the solution when you think you're good with it.
Five Stars

Re: [resolved] How to Get Row count from Hive Table

I have resolve this problem using below two modifications. 

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