Member since
07-25-2022
23
Posts
7
Kudos Received
4
Solutions
My Accepted Solutions
Title | Views | Posted |
---|---|---|
889 | 11-06-2024 02:11 PM | |
707 | 08-14-2024 01:31 PM | |
1950 | 08-14-2024 12:52 PM | |
827 | 04-04-2024 08:45 AM |
02-28-2025
02:03 PM
Thank you @MattWho for details. As you mentioned, I will post my usecase in the jira. Thanks for your help!
... View more
02-28-2025
08:52 AM
Hi @MattWho Thanks for info about PutDatabaseRecord cache. We would like to keep PutDatabaseRecord Table schema cache to reduce DB hits. Is there any option in Nifi to force refresh this Table Schema cache?
... View more
02-27-2025
01:31 PM
Hi My one liner question: How can we ensure that the DatabaseTableSchemaRegistry recognizes changes in the table structure and updates the corresponding table schema definition? Details: Our PutDatabaseRecord processors' readers are configured to use the DatabaseTableSchemaRegistry to parse incoming JSON. We have observed multiple instances where the NiFi flow fails when the target table structure is altered, such as when columns are added or removed. When new columns are added to the target table, the PutDatabaseRecord reader does not recognize the change and continues to create insert statements without the new columns. We are unsure what may have resolved the issue, but in some instances, it was automatically resolved after a day. We suspect there may be an internal cache that is rebuilt periodically. We have no clear solution for this issue and would greatly appreciate any assistance regarding it. Our NiFi system is a 3-node cluster (version 2.1) that uses Kubernetes-based leader election and state management, without an external ZooKeeper. Thanks
... View more
Labels:
- Labels:
-
Apache NiFi
11-06-2024
02:23 PM
I was able to setup GitLabFlowRegistry in controller settings successfully (which is new feature in Nifi 2.0) From Nifi UI, I am able to import Nifi flow directly from Gitlab repository. After modifications, I was able to successfully commit into Gitlab repo, from Nifi UI. Do we have any toolkit commands to perform these operations? Currently we are using toolkit commands to deploy Nifi flow changes via CICD pipeline. Can I achieve the same with new GitLabFlowRegistry? Appreciate any help/pointers. Thanks
... View more
Labels:
- Labels:
-
Apache NiFi
11-06-2024
02:11 PM
@CommanderLaus Gitlab integration is available in latest version Nifi 2.0 (released few days ago). I was able to import and export flows directly from Gitlab repo. Note: Until Nifi 2.0M4, the file extension is "snapshot", but in 2.0 if you use Gitlab, flow config file extension should be ".json" We need to provide access token of the gitlab repository in Registry controller settings.
... View more
09-09-2024
03:47 PM
Thanks @SAMSAL for the clarification and the alternatives for looping in Nifi. We will consider using DuplicateFlowFile processor. Do you think nifi documentation should be updated to explicitly mention that it is not only for load tests but also can be used in production flows when there is need to clone flow files ?
... View more
09-06-2024
02:01 PM
1 Kudo
Appreciate any help with my above question about DuplicateFlowFile usage. @SAMSAL @MattWho
... View more
09-04-2024
02:51 PM
@AlokKumar I am not able to understand the context here. It would help to get to right solution if you can explain why the inserts into same table should be executed in certain order. However, Nifi Connection configuration settings have prioritizers. Please check screenshot below.. If you are able to set attribute "priority" with desired number, "PriorityAttributePrioritizer" can be used. Please note that these prioritizers operate on node level. You may have to test these if you have multi node nifi environment. There is a processor "EnforceOrder" which has more options to enforce execution order. You may check this processor and find out if it works. 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
... View more
09-04-2024
01:35 PM
Hi I have a question on our Nifi flow design and specifically about the usage of DuplicateFlowFile processor. The latest documentation mentions that, it is intended for load test. Does that mean, it can not be used in regular production flows? Please confirm. https://nifi.apache.org/docs/nifi-docs/components/org.apache.nifi/nifi-standard-nar/nifi-2.0.0-M4/org.apache.nifi.processors.standard.DuplicateFlowFile/index.html "Intended for load testing, this processor will create the configured number of copies of each incoming FlowFile." Please verify the current and improved designs below and advise if any implications with the new approach (where DuplicateFlowFile processor is used to clone flow files) Current Design: New Design is below (with DuplicateFlowFile processor)
... View more
Labels:
- Labels:
-
Apache NiFi
08-16-2024
08:43 AM
@Adyant001 Oracle has auto increment IDENTITY feature as below. Table definition takes care of setting primary key incremental value. No need to send this value in json payload I think all other major RDBMS have similar feature to assign auto increment value. CREATE TABLE roletab (id NUMBER GENERATED BY DEFAULT ON NULL AS IDENTITY (START WITH 1 INCREMENT BY 1 NOCYCLE), role_id NUMBER, role_name VARCHAR(100), PRIMARY KEY (id) ); INSERT INTO roletab (role_id, role_name) VALUES (10, 'Admin'); INSERT INTO roletab (role_id, role_name) VALUES (20, 'Developer'); commit; SELECT * FROM roletab; ID |ROLE_ID|ROLE_NAME| --+-------+---------+ 1 | 10 | Admin | 2 | 20 |Developer|
... View more