New Contributor
Posts: 1
Registered: ‎03-22-2019

Unable to connect to cloudera 5.13 Hive remotely



I have enabled SSL on Hive and after that, I've tried connecting to the HIVE through JDBC from DBeaver using below connection Urls


    URL1: "jdbc:hive2://hostname:10000/default;ssl=true;sslTrustStore=<path-to-truststore>;trustStorePassword=<password>"

    URL2: "jdbc:hive2://hostname:10000/default;ssl=1" 
**Error for Url1**: " Unexpected driver error occurred while connecting to database
Illegal character in path at index 57: hive2://dummyhost:00000/default;ssl=true;sslTrustStore=D:\cert\cmhost-keystore.jks;trustStorePassword=xyz"

**Error for Url2**:Could not open client transport with JDBC Uri: jdbc:hive2://;ssl=1: Invalid status 21
Invalid status 21

 Please correct me where I'm doing wrong.