Vertica hcatalog connector connectivity Issue

Jayant2015

Hi, 

 

I'm getting following error when querying hive tables using vertica hcatalog, though I have confirmed that all the jars are present.

 

poc=> select * from hcat.persons;
ERROR 3399: Failure in UDx RPC call InvokeSetExecContext(): Error in User Defined Object [VHCatSource], error code: 0
com.vertica.sdk.UdfException: Couldn't instantiate class com.vertica.hcatalogudl.HCatalogSplitsNoOpSourceFactory
at com.vertica.udxfence.UDxExecContext.findUDXFactoryInLibrary(UDxExecContext.java:354)
at com.vertica.udxfence.UDxExecContext.setupLanguageContext(UDxExecContext.java:391)
at com.vertica.udxfence.UDxExecContext.setupContext(UDxExecContext.java:437)
at com.vertica.udxfence.UDxExecContext.run(UDxExecContext.java:197)
at java.lang.Thread.run(Thread.java:745)
Caused by: java.lang.NoClassDefFoundError: org/apache/hcatalog/common/HCatException
at java.lang.Class.forName0(Native Method)
at java.lang.Class.forName(Class.java:278)
at com.vertica.udxfence.UDxExecContext.findUDXFactoryInLibrary(UDxExecContext.java:341)
... 4 more
Caused by: java.lang.ClassNotFoundException: org.apache.hcatalog.common.HCatException
at java.net.URLClassLoader$1.run(URLClassLoader.java:366)
at java.net.URLClassLoader$1.run(URLClassLoader.java:355)
at java.security.AccessController.doPrivileged(Native Method)
at java.net.URLClassLoader.findClass(URLClassLoader.java:354)
at java.lang.ClassLoader.loadClass(ClassLoader.java:425)
at sun.misc.Launcher$AppClassLoader.loadClass(Launcher.java:308)
at java.lang.ClassLoader.loadClass(ClassLoader.java:358)
... 7 more

 

I am using Hortonworks 2.3 and Vertica 7.0.1 and Hive version is hive-1.2.1.2.3.0.0

 

Any help on this would be really appreciated.

 

Thanks.