Support Questions
Find answers, ask questions, and share your expertise

Microsoft HIVE ODBC Driver data source connectivity issue in HD insight cluster

Rising Star

Hi , I am new to HD insight cluster..i want to test the connectivity of hive database using Microsoft ODBC driver

I have below details given

data souce name: ABC HIVE

host: current namenode hostname

port : 443

database: default

hive server type: hive server 2

mechanism: windows azure HDinsight servive

username:

password:

Can you please help me what is username and password here? and any other details if need to change like port number(1000)

1 REPLY 1

Contributor

@rama

Host < HiveServer2 m/c FQDN>,

Port: 10000

Hive Server Type: Hive Server 2,

Mechanism: User Name and Password,

User Name : give your name and ensure that user has access in that edge node.

Paswd: XXXXX

Refer:

http://hortonworks.com/wp-content/uploads/2014/05/Product-Guide-HDP-2.1-v1.01.pdf

if it helps don't forget to upvote

; ;