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

Windows - Hive connection issue through ODBC using Hive ODBC Driver for HDP 2.2

Solved Go to solution

Windows - Hive connection issue through ODBC using Hive ODBC Driver for HDP 2.2

Rising Star

I installed Hive ODBC Driver for HDP 2.2 on my windows 7 machine and trying to connect to hive through ODBC(hadoop istalled on CENTOS).I encoutered with following error. configs are all default. For example authentication for hiveserver2 is "none"(default).Is anything i missed out.I followed the document of hortoworks.I gave the server ip and port is 10000.I assumed hiveserver2 is running because beeline command line is working for following command

beeline -u jdbc:hive2://ip:10000

1953-fireshot-capture-8-drafts-35-bsuresh.png

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted

Re: Windows - Hive connection issue through ODBC using Hive ODBC Driver for HDP 2.2

Check your connection details and it should be like below:

Host <Give IP of HiveServer2>,

Port: 10000, Database: optional( you can specify your target as well, if you don't specify it will show default db).

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

View solution in original post

2 REPLIES 2
Highlighted

Re: Windows - Hive connection issue through ODBC using Hive ODBC Driver for HDP 2.2

Mentor

@Suresh Bonam

Can you have a look at this doc

Highlighted

Re: Windows - Hive connection issue through ODBC using Hive ODBC Driver for HDP 2.2

Check your connection details and it should be like below:

Host <Give IP of HiveServer2>,

Port: 10000, Database: optional( you can specify your target as well, if you don't specify it will show default db).

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

View solution in original post