Cloudera Community
Zainers
user rank
Explorer
My Accepted Solutions
Show All

Re: Nifi Unable to use Impala connection in the ex...

by Explorer in Support Questions
‎10-02-2025 05:48 AM
‎10-02-2025 05:48 AM
Dear Matt, Thank you for the Followup,  This is the jython script tested in jython on of the Nifi nodes, using the central location for using the impala jar files, and nifi was restarted to pickup the jar class from the nar location as well the customized location readable by nifi, and in jython it works fine, and in impala it fails. we are using nifi version 1.28.1.2.1.7 jython -J-cp "/data/01/Nifi_Scripts/Nifi_Nars/*" from java.sql import DriverManager, SQLException from java.lang import Class # JDBC Connection jdbc_url = ( "jdbc:impala://xxxxrodk08.kw.xxxx.com:21000/sandbox_bi;" "AuthMech=1;" "KrbRealm=CORP.xxx.COM.xxxx;" "KrbHostFQDN=xxxxxprodk08.sw.xxxxx.com;" "KrbServiceName=impala;" "SSL=1;" "SSLTrustStore=/var/lib/cloudera-scm-agent/agent-cert/cm-auto-global_cacerts.pem;" "SSLTrustStorePwd=xxxxxxxx" ) jdbc_driver = "com.cloudera.impala.jdbc41.Driver" Class.forName(jdbc_driver) conn = DriverManager.getConnection(jdbc_url) Regards     ... View more

Re: Error while using NiFi flow to execute Impala:...

by Explorer in Support Questions
‎10-01-2025 04:11 AM
‎10-01-2025 04:11 AM
Dear Team, The issue is with the execute script  the way i am passing does not seem to reflect the same works in jython, which is testing the script in jython first, and then adding the script in to nifi, and same location is being used in nifi execute script processor, adding the reference of the template, and nifi applog. I already have a ticket going the same but Case#: 1132791   Regards ... View more

Nifi Unable to use Impala connection in the execut...

by Explorer in Support Questions
‎09-29-2025 11:22 PM
‎09-29-2025 11:22 PM
Hi Team,  I am unable to impala in the nifi executor, as i have to use impala using a jdbc connection by placing the impalajdbc41.jar in a customized location, and when restarted the nifi the jython script worked like a charm, however when using the nifi executor it says java class path not found, why is this causing the issue. Any leads would be appreciated   Regards Khursheed ... View more
Labels:

Error while using NiFi flow to execute Impala: jav...

by Explorer in Support Questions
‎09-29-2025 05:57 AM
‎09-29-2025 05:57 AM
Hi Team, We have the following issue, we are using nifi work flow, in which we are trying to execute impala, before implementing nifi  execute script, we tested the script by using jython to test the feasibility of the connections we established is successful and able to get the count in impala, however when using the same connection configuration in nifi execute script processor, we get the java class path not found, the impala jdbc connection is placed in a customized location, impalajdbc41.jar file is not a nar, file, and the customized location is readable, as confirmed by the support and if placed in the nar file location will Please find the logs for reference as an attachment.2025-09-29 15:31:08,495 ERROR org.apache.nifi.processors.script.ExecuteScript: ExecuteScript[id=49498cfb-70fc-1ebf-ffff-fffff0fa2dc8] Processing failed org.apache.nifi.processor.exception.ProcessException: javax.script.ScriptException: java.lang.ClassNotFoundException: java.lang.ClassNotFoundException: com.cloude ra.impala.jdbc.Driver in <script> at line number 22 at org.apache.nifi.processors.script.ExecuteScript.onTrigger(ExecuteScript.java:247) at org.apache.nifi.controller.StandardProcessorNode.onTrigger(StandardProcessorNode.java:1361) at org.apache.nifi.controller.tasks.ConnectableTask.invoke(ConnectableTask.java:247) at org.apache.nifi.controller.scheduling.AbstractTimeBasedSchedulingAgent.lambda$doScheduleOnce$0(AbstractTimeBasedSchedulingAgent.java:59) at org.apache.nifi.engine.FlowEngine$2.run(FlowEngine.java:110) at java.util.concurrent.Executors$RunnableAdapter.call(Unknown Source) at java.util.concurrent.FutureTask.run(Unknown Source) at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.access$201(Unknown Source) at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.run(Unknown Source) at java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source) at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source) at java.lang.Thread.run(Unknown Source) Caused by: javax.script.ScriptException: java.lang.ClassNotFoundException: java.lang.ClassNotFoundException: com.cloudera.impala.jdbc.Driver in <script> at line n umber 22 at org.python.jsr223.PyScriptEngine.scriptException(PyScriptEngine.java:222) at org.python.jsr223.PyScriptEngine.eval(PyScriptEngine.java:59) at org.python.jsr223.PyScriptEngine.access$300(PyScriptEngine.java:20) at org.python.jsr223.PyScriptEngine$PyCompiledScript.eval(PyScriptEngine.java:250) at javax.script.CompiledScript.eval(Unknown Source) at org.apache.nifi.script.impl.JythonScriptRunner.run(JythonScriptRunner.java:63) at org.apache.nifi.processors.script.ExecuteScript.onTrigger(ExecuteScript.java:230) ... 11 common frames omitted Caused by: org.python.core.PyException: java.lang.ClassNotFoundException: java.lang.ClassNotFoundException: com.cloudera.impala.jdbc.Driver at org.python.core.Py.JavaError(Py.java:545) at org.python.core.Py.JavaError(Py.java:536) ... View more
Labels:
Contact Me
Online
Offline
Last Visited
‎07-21-2026 10:25 PM
Community Statistics
Member Since ‎01-29-2019 10:02 PM
Last Visited ‎07-21-2026 10:25 PM
Posts 5