" 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 <[email protected]> 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 <[email protected]> wrote: > >> Hello, >> >> 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: >> /etc/hadoop/conf/core-site.xml,/etc/hbase/conf/hbase-site.xml >> >> 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. >> >> Thanks, >> >> Bryan >> >> >> On Thu, May 5, 2016 at 10:59 AM, Venkatesh Bodapati < >> [email protected]> 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. >>> >> >> >
