[resolved] Retrieving Row Key from HBase table in Talend

Seven Stars

[resolved] Retrieving Row Key from HBase table in Talend

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

Accepted Solutions
Seven Stars

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

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

All Replies
Community Manager

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

Hi 
tHbaseInput doesn't have option to retrieve rowKey as column result, this is a new feature request, see jira issue.
Regards
Shong
----------------------------------------------------------
Talend | Data Agility for Modern Business
Seven Stars

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

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

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

Great,  it will be grateful if you like to share the component on Talend Exchange
----------------------------------------------------------
Talend | Data Agility for Modern Business