Hi,
While creating HCatalog schema in Kerberised Vertica getting the below error. Is there any parameter missing in schema creation since otherwise kerberise authentication is working fine.
=> CREATE HCATALOG SCHEMA test HCATALOG_SCHEMA='test' HIVESERVER2_HOSTNAME='a0410phadoops09.abcd.com';
ROLLBACK 7142: Failed to create hcatalog schema: Failure in UDx RPC call InvokeProcessPartition(): Error in User Defined Object [get_hive_metadata], error code: 0
Error occured when connecting to HiveServer2 with [jdbc:hive2://a0410phadoops09.abcd.com:10000/bdphtb;principal=hive/_HOST@HADOOP.abcd.COM;ssl=true;sslTrustStore=/var/lib/cloudera-scm-agent/agent-cert/cm-auto-global_truststore.jks;trustStorePassword=********]: Failed to execute HiveServer2 JDBC query []. Error code: 0. SQLState: 08S01. Error message: Could not open client transport with JDBC Uri: jdbc:hive2://a0410phadoops09.abcd.com:10000/bdphtb;principal=hive/_HOST@HADOOP.abcd.COM;ssl=true;sslTrustStore=/var/lib/cloudera-scm-agent/agent-cert/cm-auto-global_truststore.jks;trustStorePassword=********: Error creating the transport
com.vertica.sdk.UdfException: Failed to execute HiveServer2 JDBC query []. Error code: 0. SQLState: 08S01. Error message: Could not open client transport with JDBC Uri: jdbc:hive2://a0410phadoops09.abcd.com:10000/bdphtb;principal=hive/_HOST@HADOOP.abcd.COM;ssl=true;sslTrustStore=/var/lib/cloudera-scm-agent/agent-cert/cm-auto-global_truststore.jks;trustStorePassword=********: Error creating the transport
at com.vertica.hcatalogudl.HiveServer2Connector.runQuery(HiveServer2Connector.java:488)
at com.vertica.hcatalogudl.HiveServer2Connector.access$000(HiveServer2Connector.java:92)
at com.vertica.hcatalogudl.HiveServer2Connector$1.run(HiveServer2Connector.java:325)
at com.vertica.hcatalogudl.HiveServer2Connector$1.run(HiveServer2Connector.java:322)
at java.security.AccessController.doPrivileged(Native Method)
at javax.security.auth.Subject.doAs(Subject.java:422)
at com.vertica.hcatalogudl.HiveServer2Connector.processPartition(HiveServer2Connector.java:322)
at com.vertica.udxfence.UDxExecContext.processPartitionForUDT(UDxExecContext.java:1959)
at com.vertica.udxfence.UDxExecContext.processPartition(UDxExecContext.java:1897)
at com.vertica.udxfence.UDxExecContext.run(UDxExecContext.java:29
Regards,
Avinash
