Unable to connect to Azure HDinsight Hive DB using PyHive python

Open
#446 0 comments 0 reactions 0 assignees View on GitHub

Nobody has claimed this yet.

Assessment

Difficulty
4/5
Estimated time
3-5 days
Newbie friendliness
20/100
Issue type
Bug
Clarity
Needs clarification
Activity status
Stale
Tech stack
azure, python
Domain
cloud, databases

Research direction

Start with the PyHive hive.connect call and the Azure HDInsight Hive settings shown in the issue, then reproduce the connection attempt using the supplied host, port, authentication, SSL, and HTTP transport options. Done means establishing a successful connection and confirming that the example reaches the “connected” message.

Written by the indexing model from the issue text.

Description

Hello

I am new to Hive and bigdata.
I am trying to connect to Azure Hdinsight Hive DB using PyHive from last 2 days but unable to connect.
Code :-

from pyhive import hive
import pyodbc

host = 'XXXXXXX.azurehdinsight.net'
port = 10000
database = 'testing'
username = 'XXXX'
password = 'XXXXXXX'
driver = '{ODBC Driver 17 for SQL Server}'
conn = hive.connect(host=host, port=443, username=username, password=password, database=database, auth='CUSTOM', configuration={'ssl': 'true', 'transportMode': 'http'})
print("connected")

response:-
image

if any one have any idea how to connect to it please share. ASAP.

Dominant language
Python
Stars
1.7k
Forks
545
PR merge metrics
No merged PRs in 30d

Contributor guide

No contributing guide indexed for this repository

First steps

  1. Read the whole issue, then the project's contributing guide.
  2. Comment on the issue to say you are picking it up — it saves two people doing the same work.
  3. Fork the repository and make your change on a branch.
  4. Open a pull request that references the issue number.

More from dropbox/PyHive

All issues in dropbox/PyHive

Similar issues

More Python issues

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.