Support Questions
Find answers, ask questions, and share your expertise
Announcements
Alert: Welcome to the Unified Cloudera Community. Former HCC members be sure to read and learn how to activate your account here.

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

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

Super Collaborator

Did you install the Java JCE Unlimited strength policy jars ?

Don't have an account?
Coming from Hortonworks? Activate your account here