Skip to main content
andreas
Silver ⭐️⭐️⭐️
June 18, 2019
Solved

cannot import table from external database throw hue to impala

Hi, When trying to import table from oracle database to hive from hue qui i get the following error when i am trying to setup the jdbc connection:

Connection Failed: Error accessing the database: An error occurred while calling z:java.lang.Class.forName. : java.lang.ClassNotFoundException: oracle.jdbc.driver.OracleDriver at java.net.URLClassLoader$1.run(URLClassLoader.java:360) at java.net.URLClassLoader$1.run(URLClassLoader.java:349) at java.security.AccessController.doPrivileged(Native Method) at java.net.URLClassLoader.findClass(URLClassLoader.java:348) at java.lang.ClassLoader.loadClass(ClassLoader.java:430) at sun.misc.Launcher$AppClassLoader.loadClass(Launcher.java:323) at java.lang.ClassLoader.loadClass(ClassLoader.java:363) at java.lang.Class.forName0(Native Method) at java.lang.Class.forName(Class.java:195) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) at java.lang.reflect.Method.invoke(Method.java:606) at py4j.reflection.MethodInvoker.invoke(MethodInvoker.java:231) at py4j.reflection.ReflectionEngine.invoke(ReflectionEngine.java:381) at py4j.Gateway.invoke(Gateway.java:259) at py4j.commands.AbstractCommand.invokeMethod(AbstractCommand.java:133) at py4j.commands.CallCommand.execute(CallCommand.java:79) at py4j.GatewayConnection.run(GatewayConnection.java:209) at java.lang.Thread.run(Thread.java:748)

 

By the way sqoop from command line is working just fine

lwang
lwangAnswer
Platinum ⭐️
June 20, 2019

Hi @andreas ,

 

The jira is internally to Cloudera so you can raise a question in community to ask for an update.

 

Thanks,

Li

Li Wang, Technical Solution Manager

4 replies

lwang
Platinum ⭐️
Platinum ⭐️
June 19, 2019

Hi @andreas ,

 

What is your CM and CDH version? Unfortunately the "External DB Importer" wizard currently is not fully supported in CDH and we have an internal jira opened to track this: 

CDH-53731: Officially support connection to query regular DMBS databases

 

Please refer to above jira in the future to check the status.

 

Thanks,

Li

Translate
Li Wang, Technical Solution Manager
andreas
andreasAuthor
Silver ⭐️⭐️⭐️
June 19, 2019
Hi my current CM is 6.2 with the latest cdh.i will have a look thanks.
Translate
andreas
andreasAuthor
Silver ⭐️⭐️⭐️
June 20, 2019

How can i access the jira requested?

Translate