Support Questions
Find answers, ask questions, and share your expertise
Announcements
Alert: Welcome to the Unified Cloudera Community. Former HCC members be sure to read and learn how to activate your account here.

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

Highlighted

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

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

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

Don't have an account?
Coming from Hortonworks? Activate your account here