dropbox / dropbox/PyHive

cannot connect to presto with PyHive using LDAP authentication

Open
#256 1 comment 0 reactions 0 assignees View on GitHub
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.

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.