Support Questions
Find answers, ask questions, and share your expertise

NiFi - Delete Hbase Row

Expert Contributor

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!

1 ACCEPTED SOLUTION

Accepted Solutions

Re: NiFi - Delete Hbase Row

Super Guru

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).

View solution in original post

10 REPLIES 10

Re: NiFi - Delete Hbase Row

Super Guru

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).

View solution in original post

Re: NiFi - Delete Hbase Row

Expert Contributor

+1 for JIRA reference! Thanks! 🙂

Re: NiFi - Delete Hbase Row

Explorer

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

Explorer

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

Super Guru

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

Explorer

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

Re: NiFi - Delete Hbase Row

New Contributor

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

Re: NiFi - Delete Hbase Row

New Contributor

Can this patch be applied to  Version 1.5.0.3.1.1.0-35?  

Re: NiFi - Delete Hbase Row

Explorer

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.