This is the implementation of the Trino data handler for MindsDB.
Trino is an open-source distributed SQL query engine designed to query large data sets distributed over one or more heterogeneous data sources.
Before proceeding, ensure the following prerequisites are met:
This handler is implemented using 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.There are some optional arguments as follows:
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.In order to make use of this handler and connect to the Trino database in MindsDB, the following syntax can be used:
You can use this established connection to query your table as follows:
This is the implementation of the Trino data handler for MindsDB.
Trino is an open-source distributed SQL query engine designed to query large data sets distributed over one or more heterogeneous data sources.
Before proceeding, ensure the following prerequisites are met:
This handler is implemented using 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.There are some optional arguments as follows:
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.In order to make use of this handler and connect to the Trino database in MindsDB, the following syntax can be used:
You can use this established connection to query your table as follows: