Implementation
This handler is implemented usingpyhive
, 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, onlybasic
is supported.http_scheme
takes the value ofhttp
by default. It can be set tohttps
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.
If you installed MindsDB locally via pip, you need to install all handler dependencies manually. To do so, go to the handler’s folder (mindsdb/integrations/handlers/trino_handler) and run this command:
pip install -r requirements.txt
.