Hbase to Relational

2017-07-10 Thread Ravi Papisetti (rpapiset)
Hi, We are using NiFi 1.3.0. Trying to build a template that could take data from hbase and push into relational store (I know this is little crazy requirement☺). Using below flow to achieve this: GetHBase > EvaluateJSONPath (to extract “cells” for all column values) > ReplaceText (To remove

Re: how to use LookUpRecord processor?

2017-07-10 Thread prabhu Mahendran
Thank you for your suggestions☺ It worked On 10-Jul-2017 7:26 PM, "Bryan Bende" wrote: > I think FreeFormTextRecordSetWriter can only access fields from the > read schema, so you are correct that this would be a problem since > "Sex" wasn't in the read schema. > > You could change your CSVReader

Re: how to use LookUpRecord processor?

2017-07-10 Thread Bryan Bende
I think FreeFormTextRecordSetWriter can only access fields from the read schema, so you are correct that this would be a problem since "Sex" wasn't in the read schema. You could change your CSVReader to have 'Schema Access Strategy" -> "Use Schema Name" and then create an AvroSchemaRegistry and de