presto-python-client

presto-python-client copied to clipboard

hi, after browsing dbapi.py, I could not find how to return the field data of the row structure needs (presto command line):  receive (presto-python-client): 

katherine1191

Is there any kind of mogrification/string cleaning when formatting strings? For example, I want to execute a query like INSERT INTO table VALUES (string_value) with psycopg2, I understand it does...

keithpenrod

Is there any simple way on how to write pandas DataFrame (or csv file) into database? When writing dataframes to Postgres usually I use either `pandas.DataFrame.to_sql()` or `cursor.copy_from()` in psycopg2....

tomasjanikds

Found the solution: ``` with prestodb.dbapi.connect( host='host.namel', port=443, user='myuser', catalog='catalog', schema='schema', http_scheme='https' ) as conn: conn._http_session.verify = '/path/to/cert.pem' cur = conn.cursor() cur.execute(sql_str) ``` _Originally posted by @trabbani in https://github.com/prestodb/presto-python-client/issues/87#issuecomment-519757134_

cd1986

Performance improvements: Check log level. Allow non-default json lib.

1

- Check the log level and prevent unnecessary calls to `logger`. In testing this resulted in a 15% decrease in query time. - Allow user to pass in a different...

100LL

kerberos auth documentation

13

hi there Any example in the documentation on how to connect to a kerberized presto coordinator from your lib ? thanks by advance

parisni

nextUri should be parsed instead of being consumed directly

1

## What happend When accessing presto behind a HTTPS proxy, this python sdk won't work when trying to following up the `nextUri` from query statement. E.g., after creating a query,...

shawnzhu

Hello, It seems Unicode characters are not supported in cursors. When a Presto table has Unicode characters, UnicodeEncodeError error comes up during retrieval of cursor values. cp1252 encoding is applied....

larandvit

Add support for polling

2

This PR adds support for polling the status of presto queries, decoupling it from collection of results (fixing #63). Apologies on taking so long to get to it... life /...

matthewwardrop

Provide convenient way for loading query results into a data frame

16

I want to create a data frame from hive using Presto. I am done with it but with one exception: there are empty strings in my data which would be...

kebab-mai-haddi