dropbox / dropbox/PyHive

Unable to connect to Azure HDinsight Hive DB using PyHive python

Open
#446 0 comments 0 reactions 0 assignees View on GitHub
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:-
![image](https://user-images.githubusercontent.com/98014253/223102975-eaf5c87d-2740-4c9a-ba9f-9f0cf198eac6.png)

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.

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.