search

dropbox / PyHive

Python interface to Hive and Presto. 🐝
Other
1.67k stars 549 forks source link

cannot connect to presto with PyHive using LDAP authentication #256

Open srinivasanasm opened 5 years ago

srinivasanasm commented 5 years ago

Hi, i am trying to connect Presto for Hive MetaStore using PyHive APIs and LDAP Authentication.

i have tried below different options, but no luck

from pyhive import presto cursor = presto.connect(host='ip-address',username='username', password='password',auth='LDAP').cursor() cursor.execute("select from db-name.table-name limit 5") my_results = cursor.fetchall() from pyhive import presto cursor = presto.connect('localhost').cursor() cursor.execute('SELECT FROM my_awesome_data LIMIT 10') print cursor.fetchone() print cursor.fetchall() -- or from pyhive import presto import requests from requests.auth import HTTPBasicAuth import pandas as pd requests.packages.urllib3.disable_warnings()

conn = presto.connect(host='ip-address',port=9090,protocol='https',catalog='hive',schema='db-name',username='', requests_kwargs={'auth':HTTPBasicAuth('',''),'verify':'False'})

Also i have gone through link (https://github.com/dropbox/PyHive/blob/master/pyhive/presto.py#L92) from dropbox PyHive Github , we could not make it. Could you please help

we end up with 403, 503 and below errors File "/anaconda2/lib/python3.6/site-packages/requests/adapters.py", line 226, in cert_verify "invalid path: {0}".format(cert_loc)) OSError: Could not find a suitable TLS CA certificate bundle, invalid path: False

Could you please help me what is the proper way to connect to Presto PyHive parameters to connect.

Also we are able to connect Presto CLI and query Hive tables

kk17 commented 4 years ago

@srinivasanasm Any update for your problem? I want to connect Presto using LADP too.