Unable to connect to Azure HDinsight Hive DB using PyHive python
- Dominant language
- Python
- Stars
- 1.7k
- Forks
- 545
- PR merge metrics
- No merged PRs in 30d
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.
Contributor guide
No contributing guide indexed for this repository
Assessment
This issue has not been assessed yet.