question Re: NiFi - Delete Hbase Row in Support Questions

NiFi - Delete Hbase Row

eberezitsky — Wed, 01 Mar 2017 00:06:54 GMT

Hi All,

What is the way to delete a row from HBase table (given some rowkey) using NiFi? We are using PutHbaseCell or PutHbaseJSON for inserts and updates, but couldn't find anything (except of just "execute script", which is pretty expensive) for "delete"s.

Any ideas?

Thanks!

Re: NiFi - Delete Hbase Row

mburgess — Wed, 01 Mar 2017 01:46:26 GMT

I don't think there is any other way, besides ExecuteScript or ExecuteStreamCommand (both of which require the HBase client libraries / programs, the former of which is already in the HBase NAR). I have added NIFI-3538 to track the addition of DeleteHBase processor(s).

Re: NiFi - Delete Hbase Row

eberezitsky — Wed, 01 Mar 2017 02:35:32 GMT

+1 for JIRA reference! Thanks! 🙂

Re: NiFi - Delete Hbase Row

te04_0172 — Tue, 16 Jan 2018 15:59:21 GMT

Can you kindly let me know how can i 'merge' this pull request to our current instance so that we can access the processor?

Re: NiFi - Delete Hbase Row

te04_0172 — Tue, 16 Jan 2018 16:00:00 GMT

Hi, The Jira has been marked as "Patch available". Can you kindly let me know how can we 'install' or upgrade our instance of Nifi so that we can access this processor?

Re: NiFi - Delete Hbase Row

TimothySpann — Mon, 29 Jan 2018 00:16:49 GMT

If you have Hortonworks support contact them. Otherwise, download the code, built it via maven, then grab the HBase Delete NAR and copy to your Apache NiFi server lib directory (for each Apache NiFi server instance). This is not for people who haven't done some Apache NiFi development.

Re: NiFi - Delete Hbase Row

te04_0172 — Mon, 29 Jan 2018 16:04:39 GMT

Thanks, I was able to build the code and get the nar files.

Re: NiFi - Delete Hbase Row

dkoher — Wed, 13 Nov 2019 14:18:30 GMT

Can this patch be applied to Nifi Version 1.5.0.3.1.1.0-35?

Re: NiFi - Delete Hbase Row

dkoher — Wed, 13 Nov 2019 14:22:18 GMT

Can this patch be applied to Version 1.5.0.3.1.1.0-35?

Re: NiFi - Delete Hbase Row

Eric_B — Wed, 13 Nov 2019 14:45:22 GMT

If I can ask, why are you deleting? If you want to go through nifi, it sounds like an automated process. If it's a data retention issue, I think Hbase has a way to prune on timer. The TTL setting.

Re: NiFi - Delete Hbase Row

dkoher — Wed, 13 Nov 2019 14:48:40 GMT

After we load over 100 million notes in HBase, I will be using Nifi to listening to a live HL7 feed to keep the data current. Some of these HL7 message are delete message and the rows need to be removed from HBase.