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 !
