About IslamGamal

IslamGamal · ‎08-24-2022

Hi Everyone, Am trying to upload a template to nifi but it fails and logs show this: 2022-08-18 09:06:15,666 ERROR org.apache.nifi.groups.StandardProcessGroup: Failed to synchronize StandardProcessGroup[identifier=b2b33551-8e13-1429-bd99-94bc96edf954,name=Consume ] with Flow Registry because could not retrieve version 1 of flow with identifier bf392fe0-bc7d-4495-a182-171098c7903d in bucket 6814905d-1e2d-4d26-a303-8fb9836ee612 due to: Connection refused (Connection refused) please note that the template is generated from another NIFI instance with the same version:2.1.3.0

IslamGamal · ‎06-10-2022

Hi Matt, Thanks for alerting me, but since I need to use the extracted id array inside a sql statement and I need to refer to the id array (the only way to do that is to convert the content it to an attribute as far as I know) Please if u have an article about how to handle the heap memory let me know because i need to know the cycle and when it's been clean is it after the flowfile finish or something else in other scenarios the flowfile will contains a lot of attributes and there is millions of data coming in so I appreciate your info

IslamGamal · ‎06-10-2022

Thanks alot SAMSAL. It actually worked but I've a two points if u can help me 1. since am not regex professional, is there a regex that could produce 7532233,755163 the id inside the array separated by comma since i will be using a sql statement like this SELECT * FROM table WHERE id = ANY(ARRAY[${idArray}]) 2. even i changed the Maximum Buffer Size to 5 MB and Maximum Capture Group Length to 5000 i can see that the attribute is being duplicated with name idArray.1 Is that something i have to worry about ? while calling the attribute ?

IslamGamal · ‎06-10-2022

Hello everyone i have a content in Json (an array of id) [{"id":7532233},{"id":755163}] and i need to convert this whole array into one attribute so that i can after that refer to it in an ExecuteSql processor with statement : update column 1 where id exists(${attributeName})

Online	Offline
Last Visited	‎09-02-2022 11:40 AM

Member Since	‎12-27-2021 04:15 AM
Last Visited	‎09-02-2022 11:40 AM
Posts	4
Kudos received	1

Cloudera Community

NIFI Cannot upload template

Re: [ NIFI ] Convert the flowfile content to an at...

Re: [ NIFI ] Convert the flowfile content to an at...

[ NIFI ] Convert the flowfile content to an attrib...