pyhive
, a collection of Python DB-API and SQLAlchemy interfaces for Presto and Hive.
The required arguments to establish a connection are as follows:
user
is the database user.password
is the database password.host
is the host name, IP address, or URL.port
is the port used to make TCP/IP connection.auth
is the authentication method. Currently, only basic
is supported.http_scheme
takes the value of http
by default. It can be set to https
as well.catalog
is the catalog.schema
is the schema name.with
defines default WITH-clause (properties) for ALL tables. This parameter is experimental and might be changed or removed in future release.