Remove Duplicate Record values without cache services

[#1]

Hi All, Good Morning!

Please help me in removing Duplicate Records without using cache services (Apache NIFI)Error Log

[#2]

I never worked with Hive DB, but if it only takes avro format and you have csv you can use processor ConvertRecrod to convert a record from one format to another. In this processor you create CSV Reader service and the writer is Avro

[#3]

 Sure SAMSOL, In Hive DB, I am having a table and no need for any SQL INSERT STATEMENT.

Say HIVE DB Table has XXX, in that I have to put these Data and Error Field, Just convert to Avro works or ??? have to call insert statement processor