question Use of Sequence in Nifi without using a custom processor in Archives of Support Questions (Read Only)

Use of Sequence in Nifi without using a custom processor

joseph_c — Sat, 11 Feb 2017 19:56:33 GMT

In Nifi , I need to load a csv file to hbase and as a rowkey I want to provide a running number (like oracle sequence) to each record as the rowkey. can this be done using Nifi existing processors and not putting down any custom processor.

Re: Use of Sequence in Nifi without using a custom processor

aervits — Sun, 12 Feb 2017 05:16:19 GMT

This isnot an answer your looking for but for your own knowledge, HBase does not like sequential row keys, you will cause what's called a hot-spotting issue, AKA monotonously increasing keys. Which essentially will direct all your rows to a single region server and cause bottlenecks. Avoid at all costs, row keys need to be complex (consist of different parts) and random in nature. All that said, you can probably generate these keys with an ExecuteScript processor or something else.

Re: Use of Sequence in Nifi without using a custom processor

sunile_manjee — Sun, 12 Feb 2017 22:52:11 GMT

Yes you can. This requires state to keep track of the number. Use distributed map cache (DMC) to fetch and put your sequence. Your DMC put would be existing number plus 1.