topic Re: [resolved] Retrieving Row Key from HBase table in Talend in Talend Studio

[resolved] Retrieving Row Key from HBase table in Talend

KarthikGs — Sat, 16 Nov 2024 10:07:24 GMT

Hi,
I'm trying to read data from hbase and make some transformations on the data in expression builder using big data batch.
now i want to get the row key of the table and apply transformations on it like this,
getUUID(concat('-',cast(cus.key as string))) as customer_id.

Here "getUUID" is a routine which i'm using, and key is the row key of hbase table.

So when i basically run my job, the key of the hbase table should be picked up so that the above transformations should be applied and stored as customer_id.
So how should i get the rowkey from hbase? Either inserting the row key in to a separate column will also do.
Thanks in advance

Re: [resolved] Retrieving Row Key from HBase table in Talend

Anonymous — Mon, 20 Feb 2017 02:30:56 GMT

Hi
tHbaseInput doesn't have option to retrieve rowKey as column result, this is a new feature request, see jira issue.
Regards
Shong

Re: [resolved] Retrieving Row Key from HBase table in Talend

KarthikGs — Mon, 20 Feb 2017 10:10:00 GMT

hi shong,
I have solved it by altering the tHbaseInput code .
now my application is fetching the Row key from the hbase table.

Re: [resolved] Retrieving Row Key from HBase table in Talend

Anonymous — Tue, 21 Feb 2017 01:17:24 GMT

Great, it will be grateful if you like to share the component on Talend Exchange.