Support Questions
Find answers, ask questions, and share your expertise

Connectivity issue with HIVE meta store(MS SQL)

Connectivity issue with HIVE meta store(MS SQL)

Rising Star

Hi..Team,

I am using HDI 3.4 ..Today i am facing HIVE meta store issue and unable open the HIVE cli , while i manually start the hive meta store .it is not starting and giving below error

resource_management.core.exceptions.Fail: Execution of 'export HIVE_CONF_DIR=/usr/hdp/current/hive-metastore/conf/conf.server ; /usr/hdp/current/hive-metastore/bin/schematool -initSchema -dbType azuredb -userName fsfewrwffsfsfgwerwregdfgw -passWord [PROTECTED] -verbose' returned 1. WARNING: Use "yarn jar" to launch YARN applications. Metastore connection URL: jdbc:sqlserver://zbbprodsqlserver.database.secure.windows.net;database=zbbprodHiveOozie;encrypt=true;trustServerCertificate=true;create=false;loginTimeout=300 Metastore Connection Driver : com.microsoft.sqlserver.jdbc.SQLServerDriver Metastore connection User: fsfewrwffsfsfgwerwregdfgw Exception in thread "main" java.lang.ExceptionInInitializerError at javax.crypto.KeyAgreement.getInstance(KeyAgreement.java:179) at sun.security.ssl.JsseJce.getKeyAgreement(JsseJce.java:287) at sun.security.ssl.JsseJce.isEcAvailable(JsseJce.java:199) at sun.security.ssl.CipherSuite$KeyExchange.isAvailable(CipherSuite.java:378) at sun.security.ssl.CipherSuite.isAvailable(CipherSuite.java:194) at sun.security.ssl.SSLContextImpl.getApplicableCipherSuiteList(SSLContextImpl.java:340) at sun.security.ssl.SSLContextImpl.getDefaultCipherSuiteList(SSLContextImpl.java:298) at sun.security.ssl.SSLSocketImpl.init(SSLSocketImpl.java:593) at sun.security.ssl.SSLSocketImpl.<init>(SSLSocketImpl.java:557) at sun.security.ssl.SSLSocketFactoryImpl.createSocket(SSLSocketFactoryImpl.java:109) at com.microsoft.sqlserver.jdbc.TDSChannel.enableSSL(IOBuffer.java:1616) at com.microsoft.sqlserver.jdbc.SQLServerConnection.connectHelper(SQLServerConnection.java:1401) at com.microsoft.sqlserver.jdbc.SQLServerConnection.login(SQLServerConnection.java:1068) at com.microsoft.sqlserver.jdbc.SQLServerConnection.connectInternal(SQLServerConnection.java:904) at com.microsoft.sqlserver.jdbc.SQLServerConnection.connect(SQLServerConnection.java:451) at com.microsoft.sqlserver.jdbc.SQLServerDriver.connect(SQLServerDriver.java:1014) at java.sql.DriverManager.getConnection(DriverManager.java:571) at java.sql.DriverManager.getConnection(DriverManager.java:215) at org.apache.hive.beeline.HiveSchemaHelper.getConnectionToMetastore(HiveSchemaHelper.java:77) at org.apache.hive.beeline.HiveSchemaTool.getConnectionToMetastore(HiveSchemaTool.java:121) at org.apache.hive.beeline.HiveSchemaTool.testConnectionToMetastore(HiveSchemaTool.java:169) at org.apache.hive.beeline.HiveSchemaTool.doInit(HiveSchemaTool.java:272) at org.apache.hive.beeline.HiveSchemaTool.doInit(HiveSchemaTool.java:258) at org.apache.hive.beeline.HiveSchemaTool.main(HiveSchemaTool.java:508) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) at java.lang.reflect.Method.invoke(Method.java:606) at org.apache.hadoop.util.RunJar.run(RunJar.java:221) at org.apache.hadoop.util.RunJar.main(RunJar.java:136) Caused by: java.lang.SecurityException: Can not initialize cryptographic mechanism at javax.crypto.JceSecurity.<clinit>(JceSecurity.java:94) ... 30 more Caused by: java.lang.SecurityException: Cannot locate policy or framework files! at javax.crypto.JceSecurity.setupJurisdictionPolicies(JceSecurity.java:317) at javax.crypto.JceSecurity.access$000(JceSecurity.java:50) at javax.crypto.JceSecurity$1.run(JceSecurity.java:86) at java.security.AccessController.doPrivileged(Native Method) at javax.crypto.JceSecurity.<clinit>(JceSecurity.java:83)

1 REPLY 1
Highlighted

Re: Connectivity issue with HIVE meta store(MS SQL)

Super Collaborator

Did you install the Java JCE Unlimited strength policy jars ?