installation.md

title	slug	keyword	license
Gravitino connector installation	/trino-connector/installation	gravitino connector trino	Copyright 2023 Datastrato Pvt Ltd. This software is licensed under the Apache License version 2.

To install the Gravitino connector, you should first deploy the Trino environment, and then install the Gravitino connector plugin into Trino. Please refer to the Deploying Trino documentation and do the following steps:

1. Download the Gravitino connector tarball and unpack it. The tarball contains a single top-level directory gravitino-trino-connector-<version>, which called the connector directory.
2. Copy the connector directory to the Trino's plugin directory. Normally, the directory location is Trino-server-<version>/plugin, and the directory contains other catalogs used by Trino.
3. Add Trino JVM arguments -Dlog4j.configurationFile=file:////etc/trino/log4j2.properties to enable logging for the Gravitino connector.

Alternatively, you can build the Gravitino connector package from the sources and obtain the gravitino-trino-connector-<version>.tar.gz file in the $PROJECT/distribution directory. Please refer to the Gravitino Development documentation

Example

You can install the Gravitino connector in Trino office docker images step by step.

Running the container

Use the docker command to create a container from the trinodb/trino image. Assign it the trino-gravitino name. Run it in the background, and map the default Trino port, which is 8080, from inside the container to port 8080 on your machine.

docker run --name trino-gravitino -d -p 8080:8080 trinodb/trino:426

Run docker ps to check whether the container is running.

Installing the Gravitino connector

Download the Gravitino connector tarball and unpack it.

cd /tmp
wget https://github.com/datastrato/gravitino/releases/gravitino-trino-connector-<version>.tar.gz
tar -zxvf gravitino-trino-connector-<version>.tar.gz

You can see the connector directory gravitino-trino-connector-<version> after unpacking.

Copy the connector directory to the Trino container's plugin directory.

docker copy  /tmp/gravitino-trino-connector-<version> trino-gravitino:/lib/trino/plugin

Check the plugin directory in the container.

docker exec -it trino-gravitino /bin/bash
cd /lib/trino/plugin

Now you can see the Gravitino connector directory in the plugin directory.

Configuring the Gravitino connector

Assuming you have now started the Gravitino server on the host gravitino-server-host and already created a metalake named test, if those have not been prepared, please refer to the Gravitino getting started.

To configure Gravitino connector correctly, you need to put the following configurations to the Trino configuration file /etc/trino/catalog/gravitino.properties.

connector.name=gravitino
gravitino.url=http://gravitino-server-host:8090
gravitino.metalake=test

• The gravitino.name defines which Gravitino connector is used. It must be gravitino.
• The gravitino.metalake defines which metalake are used. It should exist in the Gravitino server.
• The gravitino.uri defines the connection information about Gravitino server. Make sure your container can access the Gravitino server.

Full configurations for Gravitino connector can be seen here

If you haven't created the metalake named test, you can use the following command to create it.

curl -X POST -H "Content-Type: application/json" -d '{"name":"test","comment":"comment","properties":{}}' http://gravitino-server-host:8090/api/metalakes

And then restart the Trino container to load the Gravitino connector.

docker restart trino-gravitino

Verifying the Gravitino connector

Use the Trino CLI to connect to the Trino container and run a query.

docker exec -it trino trino
trino> SHOW CATALOGS;
Catalog
------------------------
gravitino
jmx
memory
tpcds
tpch
system

You can see the gravitino catalog in the result set. This signifies the successful installation of the Gravitino connector.

Assuming you have created a catalog named test.jdbc-mysql in the Gravitino server, or please refer to Create a Catalog. Then you can use the Trino CLI to connect to the Trino container and run a query like this.

docker exec -it trino trino
trino> SHOW CATALOGS;
Catalog
------------------------
gravitino
jmx
memory
tpcds
tpch
system
test.jdbc-mysql

The catalog named 'test.jdbc-mysql' is the catalog that you created by gravitino server, and you can use it to access the mysql database like other Trino catalogs.