Support Questions
Find answers, ask questions, and share your expertise

Oozie Hive2 Action: No suitable driver found

Oozie Hive2 Action: No suitable driver found

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