topic Re: [resolved] How to Get Row count from Hive Table in Talend Studio

[resolved] How to Get Row count from Hive Table

Anonymous — Sat, 16 Nov 2024 11:18:36 GMT

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.

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

Anonymous — Mon, 02 Mar 2015 08:13:55 GMT

Hi umeshrakhe,

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

Best regards
Sabrina

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

Anonymous — Mon, 02 Mar 2015 08:25:41 GMT

I have resolve this problem using below two modifications.

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