How to Connect to a Hive Database with No Authentication

已回答
Avatar
Benjamin Cabalona
创建于

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

分享

3 条评论
Avatar
vasily chernov
创建于

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
创建于

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

 

0
Avatar
vasily chernov
创建于

Benjamin Cabalona,

What DataGrip version do you use?

0

请先登录再写评论。