We are trying to set up a 3 node nifi cluster on GCP virtual machine (Ubuntu). Have used a CA signed certificate for creating truststore and keystore (Followed this link for creation). Have attached them through nifi.properties file. Still getting below exception on tailing logs: 2022-05-26 18:14:26,544 INFO [main] o.a.n.c.p.AbstractNodeProtocolSender Cluster Coordinator is located at nifi-hostname:7474. Will send Cluster Connection Request to this address 2022-05-26 18:14:26,780 WARN [main] o.a.nifi.controller.StandardFlowService Failed to connect to cluster due to: org.apache.nifi.cluster.protocol.ProtocolException: Failed marshalling 'CONNECTION_REQUEST' protocol message due to: javax.net.ssl.SSLHandshakeException: PKIX path building failed: sun.security.provider.certpath.SunCertPathBuilderException: unable to find valid certification path to requested target 2022-05-26 18:14:31,783 INFO [main] o.a.n.c.c.n.LeaderElectionNodeProtocolSender Determined that Cluster Coordinator is located at nifi-hostname:7474; will use this address for sending heartbeat messages On the nifi UI seeing this  javax.net.ssl.SSLPeerUnverifiedException: Hostname xx.yy.aa.bb not verified: certificate: sha256/I6cvWHqdHyhMxgNMGFcIwjY2zssGR***hidding_something_here**wjnWezSDm4= DN: CN=Guru Prakash, OU=Comm***, O=**pna, L=Bangalore, ST=Karnataka, C=IN subjectAltNames: [] Please help 🙏 ... View more

I m new bee to nifi. I followed the below link and did the configuration and username password screen appears. But i dont know what the username and password is. Can you help me with it? https://mintopsblog.com/2017/11/01/apache-nifi-configuration/ ... View more

@Anishkumar Valsalam I honestly do not know how to extract that info from NiFi. If I find something out, I will update this thread. ... View more

Thanks Matt and Anish. It helped me a lot today 🙂 ... View more

@Anishkumar Valsalam Great. Yes you can use the same approach. To have load balancing you need lot of files. If there's only few files, NiFi will not balance because it optimizes with batching. Read this article to understand how it works : https://community.hortonworks.com/articles/109629/how-to-achieve-better-load-balancing-using-nifis-s.html Thanks ... View more

@Andrew Lim Thank you so much i have configured with local URL i can able to execute the script and the tables create as expected 🙂 ... View more

@Anishkumar Valsalam Is it normal that the xa_portal.log is 0 bytes you attached a wrong file xa_portal_sql.log The debug logs can be found in /var/log/ranger/admin/xa_portal.log Change the debug in /usr/hdp/current/ranger-admin/ews/webapp/WEB-INF/log4j.xml <categoryname="org.apache.ranger"additivity="false"> <priorityvalue="debug"/> <appender-refref="xa_log_appender"/> </category> ... View more

NiFi 1.2.0 added some alignment tools, but nothing is available NiFi 1.1.0. IN NiFi 1.20 you can select multiple components, right click to open context menu and select to align them vertically or horizontally. ----> These tools can't be used to align an entire canvas at once, but it gives you the ability to easily line up single rows or columns of processor components. In the future try to keep unrelated questions to different Hortonworks Community Connection (HCC) posts. Other HCC contributors are likely to miss questions asked within the context of an answer to another question. Thanks, Matt ... View more

@Anishkumar Valsalam You can run the command desc database <db_name>. There you can find the location of hdfs directory where the db exists and then navigate to find the creation date. From hdfs you can run this command to find the creation date hdfs dfs -stat /apps/hive/warehouse/<db_name.db> ... View more

@Bryan Bende Thank you so much it worked 🙂 you made my day... ... View more