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

Tagged:

Answers

  • deepikaymdeepikaym Employee

    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';

Leave a Comment

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