Skip to content

Latest commit

 

History

History
66 lines (49 loc) · 2.04 KB

README.md

File metadata and controls

66 lines (49 loc) · 2.04 KB

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:

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!