presto-python-client
presto-python-client copied to clipboard
prestodb
Python DB-API client for Presto
This is roughly a copy of what Trino did here https://github.com/trinodb/trino-python-client/pull/160 - with two exceptions: - no tests - I dont see dbapi tests in general in this repo -...
Support for a route/prefix when the presto backend is behind a corporate firewall on a route and presto is not managed by you.
Http scheme is not supported and raises a ValueError. Yet it is the default value that is set in Connection constructor. We should either make https the default (as in...
When we try a query like `Select * from customer LIMIT 1;` it returns error. It would have been better if we can handle from python client to process queries...
Not able to set session parameters, since it's due to nonetype object. Trying the equivalent like : set session iterative_optimizer_timeout = '20.00m'
Implement #92 by referring [PyHive](https://github.com/dropbox/PyHive/tree/master/pyhive). (Apache License 2.0)
I'm trying to call Presto SQL with a simple parameter ('SELECT * FROM my_table WHERE id=${id}' I'm getting following error: prestodb.exceptions.PrestoUserError: PrestoUserError(type=USER_ERROR, name=SYNTAX_ERROR, message="line 56:26: mismatched input '$'. Expecting: 'ALL',...
Hi I am trying to run below query to update partitions of the schema after a table update. But fetchone and fetchall are causing errors as this updating partition statement...
My table creation statement is： create table test(`word` string) PARTITIONED by(dt string, hour string) STORED as orc Execute in my code： cursor = conn.cursor() sql = f''' insert into table...
Does the client support Python 3.9 and 3.10? The doc only says it supports 3.7
