I've been wondering since I started learning NiFi why ExecuteSQL processor only returns AVRO formatted data. All community examples I've seen then convert AVRO to json and pretty much all of them then split json to multiple flows.
I found myself doing the same thing over and over and over again. Since everyone is doing it, is there a strong reason why AVRO is liked so much? And why everyone continues doing this 3 step pattern rather than providing users with an option to output json instead and another option to output one flowfile or multiple (one per record). thanks Boris