Unable to connect to Azure HDinsight Hive DB using PyHive python
Nobody has claimed this yet.
Assessment
- Difficulty
- 4/5
- Estimated time
- 3-5 days
- Newbie friendliness
- 20/100
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:-

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
- Read the whole issue, then the project's contributing guide.
- Comment on the issue to say you are picking it up — it saves two people doing the same work.
- Fork the repository and make your change on a branch.
- Open a pull request that references the issue number.
More from dropbox/PyHive
-
Difficulty 4/5 3-5 days Newbie friendliness 25/100
-
Difficulty 3/5 1-2 days Newbie friendliness 35/100
-
Difficulty 3/5 1-2 days Newbie friendliness 35/100
-
Difficulty 4/5 3-5 days Newbie friendliness 35/100
-
Difficulty 5/5 Over a week Newbie friendliness 20/100
Similar issues
-
documentation help wanted
Difficulty 2/5 1-3 hours Newbie friendliness 90/100
-
Difficulty 2/5 1-3 hours Newbie friendliness 90/100
simonw/sqlite-utils#872 ·
-
Difficulty 2/5 1-3 hours Newbie friendliness 88/100
-
Difficulty 2/5 1-3 hours Newbie friendliness 82/100
-
Difficulty 2/5 1-3 hours Newbie friendliness 78/100