About rafy

Lewis_King · ‎07-12-2022

I am an absolute newbie and was following other tutorials. 😂 I thought it was necessary to convert it to JSON to store the data into Postgresql. Thanks a lot for the help !

rafy · ‎07-12-2022

Thanks Mr @MattWho . In addition to your solution, i looked into Network Attached Storage & NFS. So i configured nfs server on the source, then configured nfs client on the destination. And lastly mount the source folder to the destination folder on restart. Thank you all.

rafy · ‎06-29-2022

Thank you Sir for the reply. Yes i have looked into them. The issue i have is that my query statement has multiple join conditions. And also the table is incremental. So, someone proposed i should convert the query to a database table view, then i can now supply the view name to any of the processors you mentioned above. Please, do you have a better approach. Thank you sir.

rafy · ‎06-29-2022

Thank you so much Mr @MattWho for comprehensive explanation on what Mr @SAMSAL earlier proposed. I really learn alot & appreciate.

cjervis · ‎06-29-2022

Congratulations on resolving your issue and thank you for sharing so it may be of assistance to others.

rafy · ‎06-28-2022

Thanks. I think your approach is better to push all overheads to the Oracle Db rather than NIFI. 👍

rafy · ‎06-27-2022

Thanks to everyone for your kind help. Eventually, i got to know that the problem is with the access policy. I got the clue from here: https://bryanbende.com/development/2016/08/30/apache-nifi-1.0.0-secure-site-to-site Thank you all.

rafy · ‎06-24-2022

Thanks for this.

rafy · ‎06-16-2022

Thanks to everyone especially @SAMSAL. I got to know it is the firewall that was blocking the communications among the ports. I tried to add those ports to firewall but no much success. When i tried to reach NIFI GUI, i ran into this error: java.net.NoRouteToHostException: No route to host (Host unreachable). So i disable the firewall & everything worked perfectly. FIRST METHOD: NO SUCCESS firewall-cmd --zone=public --permanent --add-port 9991/tcp firewall-cmd --zone=public --permanent --add-port 2888/tcp firewall-cmd --zone=public --permanent --add-port 3888/tcp firewall-cmd --zone=public --permanent --add-port 2181/tcp firewall-cmd --reload SECOND METHOD: SUCCESS systemctl stop firewalld

EldarB · ‎06-16-2022

Just add this ports to firewalld

Online	Offline
Last Visited	‎09-19-2024 02:09 AM

Member Since	‎01-26-2022 04:36 AM
Last Visited	‎09-19-2024 02:09 AM
Posts	82
Kudos received	2

Cloudera Community

Re: Timestamp migration issue, PutDatabaseRecord d...

Re: Custom processor: IOUtils cannot be resolved

Re: Unable to generate client certificate for Mini...

Re: Very Strange: Nifi Flow does not have Input po...

Re: Error Nifi Cluster Setup: Attempted to registe...

Re: Spliting CSV files into 2 and saving them on P...

Re: PutFile processor not showing error but file c...

Re: Data migration: Which processor to use?

Re: Can NIFI nodes access different records on a D...

Re: Unable to generate client certificate for Mini...

Re: Query Oracle Database with join statement

Re: Very Strange: Nifi Flow does not have Input po...

Re: NiFi cluster sandbox on Docker

Re: Error Nifi Cluster Setup: Attempted to registe...

Re: Nifi : Unable to elect cluster coordinator