cannot connect to presto with PyHive using LDAP authentication
- Dominant language
- Python
- Stars
- 1.7k
- Forks
- 545
- PR merge metrics
- No merged PRs in 30d
Description
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
Contributor guide
No contributing guide indexed for this repository
Assessment
This issue has not been assessed yet.