question NiFi - ConvertCSVtoAVRO (without inferring schema) - how to rename the output file? in Archives of Support Questions (Read Only)

NiFi - ConvertCSVtoAVRO (without inferring schema) - how to rename the output file?

michal_rudko — Fri, 20 Jan 2017 22:56:17 GMT

Hi,

I am using ConvertCSVtoAVRO transformation in NiFi to obtain an avro file (from local to local address) with a predefined schema.

All the records successfully go through, however I cannot find a place in PutFile block (connected direclty to ConvertCSVtoAVRO) where I can change the filename.

Does anyone know how to do it?

Let's assume I have input.csv and want to obtain output.avro file.

Thanks, Michal

Re: NiFi - ConvertCSVtoAVRO (without inferring schema) - how to rename the output file?

bbende — Fri, 20 Jan 2017 22:58:49 GMT

You can use an UpdateAttribute processor and change the 'filename' attribute.

Re: NiFi - ConvertCSVtoAVRO (without inferring schema) - how to rename the output file?

pvillard — Fri, 20 Jan 2017 22:58:56 GMT

Hi @Michal R,

What you are looking for can be achieved with an UpdateAttribute processor, and you just need to update the 'filename' attribute, this is the attribute used by the PutFile processor.

Hope this helps.

Re: NiFi - ConvertCSVtoAVRO (without inferring schema) - how to rename the output file?

MattWho — Mon, 19 Aug 2019 08:32:38 GMT

@Michal R

You can use an UpdateAttribute processor to change the filename.

However, this would end up with every file having the same filename.

Assuming each input filename is unique excpet has a .csv extension, you could do the following:

This would essentially replace the .csv extension with .avro while leaving the rest of the original filename unchanged.

Thanks,

Matt