" Missing Row id failure, routing to failure " issue solved . Still i got the "failed to receive data from Hbase due to java net connection exception :Connection Refused" error in GetHbase Processor.  I update Hbase-Site.xml and remove remaining properties like " Zookeeper Quorum Info,Zookeeper Client Port Info . still i got the same error in GetHbase processor.

On Thu, May 5, 2016 at 9:07 PM, Bryan Bende <bbende@gmail.com> wrote:
I was looking at this a little more and instead of needing the RouteOnAttribute, I think you can just update EvaluateJsonPath properties...

Based on the JSON I see coming in, they should be:

email = $.email
firstName = $.name.first
lastName = $.name.last
ssn = $.id.value

On Thu, May 5, 2016 at 11:30 AM, Bryan Bende <bbende@gmail.com> wrote:

For HBaseClient, are you sure your ZooKeeper being used by HBase is running on localhost:2181?

Typically you don't really need to set the three ZooKeeper properties, and you can instead just set the hbase-site.xml in the config resources. 

For example, my Hadoop Configuration Resources is set as:

And then I don't have anything specified for ZooKeeper QuorumInfo, etc., because hbase-site.xml is providing all that information.

The example template requires a Users table, so from Hbase shell:
create 'Users', {NAME => 'cf'}

Then the template has a slight problem where it is using EvaluteJsonPath to extract an attribute called "ssn" and using that for the row id... the problem is a lot of the ssn values are empty so they are failing.

If you stick a RouteOnAttribute right after EvaluateJsonPath, and add a property "matched" = ${ssn:isEmpty():not()} that will filter out all the empty SSNs, then connect RouteOnAttribute's matched relationship to the HBase processors.

Lets get the inserting side working and then I would expect the GetHBase to work since they use the same underlying connection.



On Thu, May 5, 2016 at 10:59 AM, Venkatesh Bodapati <venkatesh.bodapati@inndata.in> wrote:
I am working on "Fun_With_Hbase.xml" Template. In this i will send data to hbase table, but i will not get data from hbase. I will get the "failed to receive data from hbase due to java net connection exception :Connection Refused" error in GetHbase Processor and In PutHbaseCell,PutHbaseJson Processor i got error Like This " Missing Row id failure, routing to failure ". 

This is my HbaseClient Properties :

Hadoop Configuration FilesInfo  : /usr/local/hadoop/hadoop-2.6.0/etc/hadoop/core-site.xml,/usr/local/hadoop/hadoop-2.6.0/etc/hadoop/hdfs-site.xml
ZooKeeper QuorumInfo            : localhost:2181
ZooKeeper Client PortInfo        : 2181
ZooKeeper ZNode ParentInfo   : /hbase
HBase Client RetriesInfo           : 1

How do i get data from Hbase Table in Nifi,Any suggesions please.