trino docker compose

This project aims to provide a simple and efficient development and testing environment for developers and anyone interested in exploring Trino.

The setup includes:

• MinIO Catalog: Pre-configured to use the Hive Metastore connector. MinIO serves as an S3-compatible object storage, enabling you to query bucket-stored data as traditional tables.
• Faker Catalog: Generates realistic synthetic data for testing queries and application functionality without relying on external datasets.
• Dynamic Catalog: easily add your own catalogs by executing Trino's CREATE CATALOG queries.

Credits

This project is built on top of two existing repositories, modified and updated for a modern Trino experience.
Instead of forking the original projects, I made significant modifications, removing certain functionalities and adding custom features.
Original Repositories:

• trino-hive-docker

• trino-dbt

Special thanks to the contributors of both projects!

Getting Started

To get started, follow these simple steps:

1. Ensure that Docker is installed on your machine.
2. clone project
3. Navigate to the project directory in your terminal or command prompt.
4. Run the following command:

   docker-compose up

thats it!

Trino Cli:

1. Open Docker Desktop.
2. Enter the terminal of the Trino container.
3. Type trino to start the CLI.

Python Client:

1. pip install trino

2.  import trino
   
    conn = trino.dbapi.connect(
        host='localhost',
        port=8080,
        user='your-username',
    )
    cursor = conn.cursor()
   
    cursor.execute("SHOW CATALOGS")
   
    for row in cursor.fetchall():
        print(row)
   
    cursor = conn.cursor()
   
    cursor.execute("SHOW CATALOGS")
   
    for row in cursor.fetchall():
        print(row)

Contribute & Support

If you like the project, please help us stay relevant by contributing and sharing your feedback.

Happy querying!