I was working with NIFI to ingest csv file into postgresql. But I have many different csv file so cannot define specific avro schema. So I use inferavroschema processor. But there is some problem
1. I have to ingest csv file which have timestamp type column. But when I run inferavroschema processor, it define the type of column as string
2. If first row of column is null, processor define the type of column as string, even though its original type is integer or double
So what I figured out was to retrieve the avroschema from the table in the database using the filename, but I do not know if there is a processor that does this. Can anyone help me with this?