The Vertica Forum recently got a makeover! Let us know what you think by filling out this short, anonymous survey.

Vertica hcatalog connector connectivity Issue

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.

Leave a Comment

BoldItalicStrikethroughOrdered listUnordered list
Emoji
Image
Align leftAlign centerAlign rightToggle HTML viewToggle full pageToggle lights
Drop image/file

Can't find what you're looking for? Search the Vertica Documentation, Knowledge Base, or Blog for more information.