Unable to create schema in hcatalog
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
Answers
Hi Avinash,
Can you try the create statement using WITH like below and check if you are still seeing issue:
CREATE HCATALOG SCHEMA test HCATALOG_SCHEMA='test' WITH HIVESERVER2_HOSTNAME='a0410phadoops09.abcd.com';