We're Moving!

The Vertica Forum is moving to a new OpenText Analytics Database (Vertica) Community.

Join us there to post discussion topics, learn about

product releases, share tips, access the blog, and much more.

Create My New Community Account Now


hcatalog install error in vertica (9.2) — Vertica Forum

hcatalog install error in vertica (9.2)

DNelgiDNelgi Vertica Employee Employee

Hello folks ,
when i tried to install hcatalog connector, I am facing the below error:
\i '/opt/vertica/packages/hcat/ddl/install.sql'
vsql:/opt/vertica/packages/hcat/ddl/install.sql:13: ROLLBACK 7143: Failed to create library VHCatalogLib because no required jar files are found in dependency paths[/opt/vertica/packages/hcat/lib/.]
HINT: Please refer to documentation for how to copy required dependency jars from Hadoop cluster using hcatUtil
vsql:/opt/vertica/packages/hcat/ddl/install.sql:16: ROLLBACK 3861: Library not found: public.VHCatalogLib
vsql:/opt/vertica/packages/hcat/ddl/install.sql:17: ROLLBACK 2059: Source with specified name and parameters does not exist: VHCatSource
vsql:/opt/vertica/packages/hcat/ddl/install.sql:18: ROLLBACK 3861: Library not found: public.VHCatalogLib
vsql:/opt/vertica/packages/hcat/ddl/install.sql:19: ROLLBACK 2059: Parser with specified name and parameters does not exist: VHCatParser
vsql:/opt/vertica/packages/hcat/ddl/install.sql:20: ROLLBACK 3861: Library not found: public.VHCatalogLib
vsql:/opt/vertica/packages/hcat/ddl/install.sql:21: ROLLBACK 2059: Function with specified name and parameters does not exist: get_hadoop_info
vsql:/opt/vertica/packages/hcat/ddl/install.sql:22: ROLLBACK 3861: Library not found: public.VHCatalogLib
vsql:/opt/vertica/packages/hcat/ddl/install.sql:23: ROLLBACK 2059: Transform Function with specified name and parameters does not exist: get_hive_metadata

I also tried adding the missing jars from external websites and ran the following verify jars and the results are as follows:
./hcatUtil --verifyJars --hcatLibPath=/opt/vertica/packages/hcat/lib
Looking at [/opt/vertica/packages/hcat/lib] for Jars
SUCCESS: Found all required Jars.
SUCCESS: Found all optional Serde and Codec Jars.
SUCCESS: Found all HDP required Jars.
SUCCESS: Found all CDH required Jars.
SUCCESS: Found all MapR required Jars.
SUCCESS: Found all native libraries

Summary

Found 42 out of 42 required JARs
Found 5 out of 5 optional Serde and Codec JARs
Found 2 out of 2 HDP required JARs
Found 1 out of 1 CDH required JARs
Found 3 out of 3 MapR required JARs
Found 3 out of 3 optional native libraries, 4 files in total
Looking at [/opt/vertica/packages/hcat/lib] for configuration files
Found configuration file [hdfs-site.xml]
Found configuration file [yarn-site.xml]
Found configuration file [core-site.xml]
Found configuration file [ssl-client.xml]
Found configuration file [hive-site.xml]
Found configuration file [webhcat-default.xml]

Thanks in advance!

Answers

  • SruthiASruthiA Administrator

    What is your vertica version and Hadoop Version? Can you set parameter HCatalogConnectorUseHiveServer2 to 0 and try the install again?

Leave a Comment

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