Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
hbandari3636
Contributor III
Contributor III

Problems in connecting to Hive database throwing a error

Hi All,

I was trying to connect to Hive database with the JDBC Connector and I am facing the following screenshot error. Below process is the following which we have done by using the cloudera JDBC jars and the below process is suggested by Cloudera JDBC support.

You must set the KRB5CCNAME environment variable to your credential cache file.

To set the KRB5CCNAME environment variable:

1. Click the Start button , then right-click Computer, and then click Properties.

2. Click Advanced System Settings.

3. In the System Properties dialog box, on the Advanced tab, click Environment Variables.

4. In the Environment Variables dialog box, under the System variables list, click New.

5. In the New System Variable dialog box, in the Variable name field, type KRB5CCNAME.

6. In the Variable Value field, type the path for your credential cache file. For example, type

C:\KerberosTickets.txt.

Please let me know if anybody have solution for this.

Thanks in advance.

Regards

Hemantha

2 Replies
Gysbert_Wassenaar

No idea. Perhaps rbecher‌ can help you.


talk is cheap, supply exceeds demand
rbecher
MVP
MVP

Hi Hemantha,

we provide professional support to set up our product JDBC Connector in complex environments. Just get in touch directy: ralf.becher@tiq-solutions.de

- Ralf

Astrato.io Head of R&D