Using the HCatalog Connector -error

sarafumes

Hi , I am trying the run the ddl script
i have also altered my database

ALTER DATABASE prometheus SET JavaClassPathSuffixForUDx = '/home/centos/hadoop_conf';

dbadmin=> \i /opt/vertica/packages/hcat/ddl/install.sql
vsql:/opt/vertica/packages/hcat/ddl/install.sql:13: NOTICE 6792: Found Hadoop configuration files in dependency paths. If any of the configuration files is changed, please re-install HCatalog connector library with modified configuration files
vsql:/opt/vertica/packages/hcat/ddl/install.sql:13: ROLLBACK 2175: An error occurred when loading library file on node v_prometheus_node0002, message:
Couldn't create new UDx side process: Java Binary not found: /usr/bin/java
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

please suggest !

xiaowei_zhu

Looks like the following parameter you need to set properly to your java binary:

alter DATABASE :dbname set parameter JavaBinaryForUDx='/path/to/java'