Support Questions
Find answers, ask questions, and share your expertise
Announcements
Alert: Welcome to the Unified Cloudera Community. Former HCC members be sure to read and learn how to activate your account here.

Oozie Hive2 Action: No suitable driver found

Highlighted

Oozie Hive2 Action: No suitable driver found

New Contributor

Hello,

We have been building out some pipelines in Oozie and have started making some progress, but there is an issue we are having. In our kerberized cluster, I am trying to run a simple oozie job to just show databases in hive. When I run the below job I get the following error:

java.sql.SQLException: No suitable driver found for "jdbc:hive2://[ZOOKEEPER_QUORAM]/;serviceDiscoveryMode=zooKeeper;zooKeeperNamespace=hiveserver2";principal="hive/[HOSTNAME]@AD.POPULYTICS.COM" at java.sql.DriverManager.getConnection(DriverManager.java:689)

Which doesn't make any sense, I have even tried including the standalone driver in the files section of the job with no difference. Any help would be greatly appreciated, there doesn't appear to be a lot of reference material out there with hive2 action with Zookeeper.

<?xml version="1.0" encoding="UTF-8" standalone="no"?><workflow-app xmlns="uri:oozie:workflow:0.5" name="HiveTest">
    <credentials>
        <credential name="hive2" type="hive2">
            <property>
                <name>hive2.jdbc.url</name>
                <value>"jdbc:hive2://[ZOOKEEPER_QUORAM]/;serviceDiscoveryMode=zooKeeper;zooKeeperNamespace=hiveserver2"</value>
            </property>
            <property>
                <name>hive2.server.principal</name>
                <value>"hive/[HOSTNAME]@AD.POPULYTICS.COM"</value>
            </property>
        </credential>
    </credentials>
    <start to="hive2_1"/>
    <action cred="hive2" name="hive2_1">
        <hive2 xmlns="uri:oozie:hive2-action:0.2">
            <job-tracker>${resourceManager}</job-tracker>
            <name-node>${nameNode}</name-node>
            <job-xml>[HDFSPATH]/output/hive-site.xml</job-xml>
            <configuration>
                <property>
                    <name>oozie.use.system.libpath</name>
                    <value>true</value>
                </property>
                <property>
                    <name>oozie.wf.application.path</name>
                    <value>hdfs://popul/user/npileggi/hivetest.xml</value>
                </property>
            </configuration>
            <jdbc-url>jdbc:hive2://popul-vmmn01.inetuhosted.net:2181,popul-vmmn02.inetuhosted.net:2181,popul-vmmn03.inetuhosted.net:2181/;serviceDiscoveryMode=zooKeeper;zooKeeperNamespace=hiveserver2</jdbc-url>
            <query>SHOW DATABASES;</query>
            <file>[HDFSPATH]/output/hive-site.xml</file>
            <archive></archive>
        </hive2>
        <ok to="end"/>
        <error to="kill"/>
    </action>
    <kill name="kill">
        <message>${wf:errorMessage(wf:lastErrorNode())}</message>
    </kill>
    <end name="end"/>
</workflow-app>

Thanks,

Nick