I haven't tried it, but I think you need to create trust store/key store file using existing certificates.
*keytool -import -alias <alias> -file <path-to-cerficate-file> -keystore <truststorefile>* And then you need to provide the TrustStore location in jdbc connection string jdbc:Host://<host>:port>/<database>;ssl=true;* sslTrustStore=<path-to-truststore>*;sslTrustStorePassword=<password> Hope this will help you. Thanks On Tue, Oct 29, 2013 at 1:40 PM, Kanwaljit Singh <batman.n...@gmail.com> wrote: > Hi, > > In my deployment I have an SSL connection only PostGre SQL server. > > I tried giving the postgres IP with &SSL=true, but Hive is unable to find > the certificates. I have no clue where Hive or PG's JDBC client driver look > for certificates. Any help in this regard would be appreciated! > > On Tue, Oct 29, 2013 at 1:40 PM, Kanwaljit Singh <batman.n...@gmail.com>wrote: > Hi, > > In my deployment I have an SSL connection only PostGre SQL server. > > I tried giving the postgres IP with &SSL=true, but Hive is unable to find > the certificates. I have no clue where Hive or PG's JDBC client driver look > for certificates. Any help in this regard would be appreciated! >