@Runa27  management.server.address -- defines HTTP URL on which NiFi listens for management requests. Doc Ref : https://nifi.apache.org/nifi-docs/administration-guide.html Please try setting below property as part of " bootstrap.conf " and then start the Nifi service. java.arg.mng12=-Dorg.apache.nifi.management.server.address=127.0.0.1:<port-number> Please check if the port-number <for example: 9990> is not defined and replace the same in the property  Please help our community grow. If you found any of the suggestions/solutions provided helped you with solving your issue or answering your question, please take a moment to login and click "Accept as Solution" on one or more of them that helped. ThankYou, Hari ... View more

@broobalaji Not sure if the processor is validated successfully. Please check all the files ( config files ) provided are accessible by nifi user and the properties defined are correct in the put hdfs processor  Cloudera Reference Doc : https://docs.cloudera.com/cfm/4.0.0/nifi-ozone/topics/cfm-ozone-target.html ... View more

1. Check if you have any Hints (Broadcast) set at the query level .  2. try increasing spark.sql.shuffle.partitions 3. you can set SQL HINTS such as MERGE to use sort merge join , instead of broadcast*  ... View more