About ariel12

ariel12 · ‎12-07-2023

Hello @SAMSAL , sorry for the late response, my issue is the the data in json is always visible ,i need to insert to the db only the data that was not insert the last run (the task run every 5sec) , so now every 5 sec the task insert all the json data so i have many rows with the same values , my end goal is to every 5 sec to insert only data that is not already in the db from the json sorry for the confusion

ariel12 · ‎12-04-2023

@SAMSAL very much , thank you!

ariel12 · ‎12-03-2023

Thank you very much for your help and support @SAMSAL ,this defiantly did the trick , its working perfect ! (now i have new issue that i didn't think about , since i am pulling the json file every X time the insert to the DB contain the same value with the same time value. i need to find a way to put filter or something to prevent multi insert with the same values thanks a lot !

ariel12 · ‎12-03-2023

Hello all, i am new to Nifi , i have Processor to InvokeHTTP and get json file , the json format example: " {"alertDate":"2023-12-03 11:01:17","title":"XXXX","data":"XXXX, XXXX, XXXX","category":1}" " i am using the Processor ConvertJSONToSQL to send the data to PutSQL to insert to my sql data base , my issue is : PutSQL Failed to update database for FlowFile due to The value of the sql.args.1.value is '2023-12-02 10:54:38', which cannot be converted to a timestamp" know i need to use the JoltTransformJSON but not sure what is the correct Jolt Specification i need to put, my DB columns are like this can you please help? - remember i am new to Nifi 🙂 thanks a lot!

Online	Offline
Last Visited	‎01-22-2024 03:57 AM

Member Since	‎12-03-2023 02:57 AM
Last Visited	‎01-22-2024 03:57 AM
Posts	4

Cloudera Community

Re: PutSQL time format issue

Re: PutSQL time format issue

Re: PutSQL time format issue

PutSQL time format issue