7

I'm trying to get my head around on extracting attributes from Avro and JSON. I'm able to extract attributes from JSON by using EvaluateJsonPath processor. I'm trying to do the same on Avro, but i'm not sure whether it is achievable.

Here is my flow, ExecuteSQL -> SplitAvro -> UpdateAttribute

UpdateAttribute is the processor where i want to extract the attributes. Please find below snapshot of UpdateAttribute processor,

UpdateAttribute Processor COnfiguration

So, my basic question is, could we extract attributes form Avro? If yes, please provide me the right approach. Or is it necessary to use ConvertAvroToJSON always before extracting the attributes?

Pons
  • 1,101
  • 1
  • 11
  • 20

1 Answers1

14

Currently, there is no way in NiFi to extract attributes directly from Avro (there is not yet an AvroPath like XPath for XML or JsonPath for JSON) so as you said you can use ConvertAvroToJSON before extracting the attributes.

Alternatively, I wrote a Groovy script for use in an ExecuteScript processor, it takes "Avro path" values as dynamic properties (each starting with avro.path and whose value is really JsonPath), does the conversion of Avro to JSON in memory, and requires you download and point to the Avro JARs. I can post it here if you are interested, but really its only advantage is to maintain the flow file content in Avro, and although it might be annoying, you could use ConvertAvroToJson -> EvaluateJsonPath -> ConvertJsonToAvro as the workaround.

mattyb
  • 11,693
  • 15
  • 20
  • 1
    thanks again for helping. I will use `ConvertAvroToJson` -> `EvaluateJsonPath` -> `ConvertJsonToAvro` as the workaround – Pons Feb 28 '17 at 06:43
  • Couldn't you also extract the attributes from the JSON content and then merge the attributes back onto the flowfile with the Avro content? – Andy Feb 28 '17 at 17:18
  • @Andy, i can extract the attributes from JSON using `EvaluateJSONPath`. But have never tried to merge the attributes with the Avro. I was trying to extract attributes from Avro and Json. – Pons Feb 28 '17 at 17:51