How to Connect to a Hive Database with No Authentication

Answered
Avatar
Benjamin Cabalona
Created

I'm connected to a hive database in tableau with no authentication, and the transport is binary. How do i do it in DataGrip?

Votes

0

Share

3 comments
Avatar
vasily chernov
Created

Sorry for the late reply.

You can set Authentication to No auth:

and specify transportMode option in JBDC connection URL, e.g.:

jdbc:hive2://<host>:<port>/<db>;transportMode=http;httpPath=<http_endpoint>

where:

  • <http_endpoint> is the corresponding HTTP endpoint configured in hive-site.xml. Default value is cliservice.
  • Default port for HTTP transport mode is 10001.

Article for reference:

 

0
Avatar
Benjamin Cabalona
Created

Hi vasily chernov I can't see the option for authentication

 

0
Avatar
vasily chernov
Created

Benjamin Cabalona,

What DataGrip version do you use?

0

Please sign in to leave a comment.