https://community.cloudera.com/t5/Support-Questions/How-to-insert-into-db-in-order-file-contains-the-data-using/m-p/392712#M248218 <P>I have a simple file having say 1000 lines each of which contains say username and useraddress. I need to insert it into db. How to insert it in order. I am able to use PutFile and PutDatabaseRecord both for the insertion purpose. But they insert randomly in any order. I wanted it to be inserted in the same order it is present in the file.</P><P>How to do that.</P> Wed, 28 Aug 2024 15:42:46 GMT AlokKumar 2024-08-28T15:42:46Z https://community.cloudera.com/t5/Support-Questions/How-to-insert-into-db-in-order-file-contains-the-data-using/m-p/392712#M248218 <P>I have a simple file having say 1000 lines each of which contains say username and useraddress. I need to insert it into db. How to insert it in order. I am able to use PutFile and PutDatabaseRecord both for the insertion purpose. But they insert randomly in any order. I wanted it to be inserted in the same order it is present in the file.</P><P>How to do that.</P> Wed, 28 Aug 2024 15:42:46 GMT https://community.cloudera.com/t5/Support-Questions/How-to-insert-into-db-in-order-file-contains-the-data-using/m-p/392712#M248218 AlokKumar 2024-08-28T15:42:46Z https://community.cloudera.com/t5/Support-Questions/How-to-insert-into-db-in-order-file-contains-the-data-using/m-p/393077#M248329 <P><a href="https://community.cloudera.com/t5/user/viewprofilepage/user-id/114561">@AlokKumar</a>&nbsp;</P><P>I am not able to understand the context here.&nbsp; &nbsp;It would help to get to right solution if you can explain why the inserts into same table should be executed in certain order.&nbsp;&nbsp;</P><P>However, Nifi Connection configuration settings have prioritizers.&nbsp; Please check screenshot below..</P><P>If you are able to set attribute "priority" with desired number, "PriorityAttributePrioritizer" can be used.&nbsp; Please note that these prioritizers operate on node level.&nbsp; You may have to test these if you have multi node nifi environment.&nbsp;</P><P>There is a processor "EnforceOrder" which has more options to enforce execution order.&nbsp; You may check this processor and find out if it works.</P><P><A href="https://nifi.apache.org/docs/nifi-docs/components/org.apache.nifi/nifi-standard-nar/nifi2.0-m4/org.apache.nifi.processors.standard.EnforceOrder/index.html" target="_blank">https://nifi.apache.org/docs/nifi-docs/components/org.apache.nifi/nifi-standard-nar/nifi2.0-m4/org.apache.nifi.processors.standard.EnforceOrder/index.html</A></P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="shiva239_0-1725483625036.png" style="width: 999px;"><img src="https://community.cloudera.com/t5/image/serverpage/image-id/41657iE3B865A953207A3A/image-size/large?v=v2&amp;px=999" role="button" title="shiva239_0-1725483625036.png" alt="shiva239_0-1725483625036.png" /></span></P><P>&nbsp;</P> Wed, 04 Sep 2024 21:51:34 GMT https://community.cloudera.com/t5/Support-Questions/How-to-insert-into-db-in-order-file-contains-the-data-using/m-p/393077#M248329 shiva239 2024-09-04T21:51:34Z