ExecuteSQL will use Database Connection Pooling Service controller service. From there you configure a JDBC connection string. The connection string will depend on the specific jar you will use so in this case Presto Here is reference on JDBC connection for Presto and that is an external database function and not so much NiFi issue:   https://prestodb.io/docs/current/installation/jdbc.html ... View more

Hello @alim,   Can you please indicate where I can find the ./conf/providers.xml file ? Also regarding this "Flow snapshot histories are managed as Git commits, meaning only the latest version of Buckets and Flows exist in the Git directory.", is there any way to save all versions of a specific flow in GIT?   Thank you! ... View more

Hi , If you are still on the lookout for some help I would be glad to help you out, as I have in the past worked on some very complex projects involving Cloudera. Cheers and Have a great day ahead, Andrew ... View more

Hi Friends    I tried running the curl from my Linux session on which Nifi installed. This is a secured nifi instance . I got the forbidden error. Please see the error below    -bash-4.2$ curl -i -X PUT -H 'Content-Type: application/json' -d '{"id":"e3d11d1d-327b-1b5b-96a7-3cb59c48df17","state":"RUNNING"}' https://XXXXX:8443/nifi//nifi-api/flow/process-groups/e3d11d1d-327b-1b5b-96a7-3cb59c48df17; HTTP/1.1 403 Forbidden Server: squid/3.5.20 Mime-Version: 1.0 Date: Tue, 07 Jul 2020 09:34:57 GMT Content-Type: text/html;charset=utf-8 Content-Length: 3347 X-Squid-Error: ERR_ACCESS_DENIED 0 Vary: Accept-Language Content-Language: en X-Cache: MISS from XXXXX X-Cache-Lookup: NONE from XXXX Via: 1.1 XXXXXsquid/3.5.20) Connection: keep-alive curl: (56) Received HTTP code 403 from proxy after CONNECT   @Shu_ashu - can you please help me here sir. Is it that I need to specify the certs somewhere ? ... View more

Hi @GangWar , Thanks for your sharing, how ever I tried with image     apache/nifi:latest https://hub.docker.com/r/apache/nifi/ My expectation is mount folder /opt/nifi/nifi-current/conf (inside nifi-container) to folder nifi (in docker-machine). However it doesnot work.   Do you have any suggestions? ... View more

thanks @MattWho ... View more

Hi Alim,   I just started to repeat our work and found the following error.  My testing environment is : Ubuntu 16.04;  MySQL and NiFi are installed in the system, I could access to MySQL via the terminal in a remote Windows PC. Does anyone know how to address the issue? Thanks. Kind regards,   Raymond ... View more

You can change the variables with REST API, but I wouldn't suggest this. 1. In this case within NIFI Cluster version numbers could be different between Nodes 2. After variable update a restart is required for controller and processor too (it doesn't matter if you changing it with REST API, or with other methods), you can check the process, when you manually changing it.   It's better to create a flowfile with attributes, or write-back data to sources (if it's a database), and compare it from there if possible. If you have an another solution, please share it :). ... View more

Splits a JSON File into multiple, separate FlowFiles for an array element specified by a JsonPath expression. Each generated FlowFile is comprised of an element of the specified array and transferred to relationship 'split,' with the original file transferred to the 'original' relationship. If the specified JsonPath is not found or does not evaluate to an array element, the original file is routed to 'failure' and no files are generated. regards, titaniumtv download ... View more

There is a mongo-java-driver you can use in either Groovy or Javascript (or any of the scripted languages in ExecuteScript), check my blog on how to use modules. ... View more