मुख्य विषयवस्तु में जाएं

त्रिगुण

Trino is a distributed SQL query engine designed for interactive analytics on medium-to-large datasets. In Ilum, Trino is exposed through the Apache Kyuubi SQL gateway as a peer engine alongside Spark, DuckDB, and Flink.

Trino is disabled by default in the Helm chart and enabled per deployment.

When to use Trino​

Trino is the right engine for:

  • Interactive dashboards and BI workloads.
  • Sub-second exploratory queries on medium-to-large data.
  • Federated queries across multiple data sources (relational databases, NoSQL stores, lake catalogs).
  • Workloads that benefit from low latency over peak throughput.

For heavy transformations, ML pipelines, and large-scale ETL, prefer अपाचे स्पार्क . For small-data and local execution, prefer डकडीबी .

Execution model​

Trino uses a coordinator-worker topology with always-on workers:

  • Coordinator: Receives queries, plans execution, distributes work to workers.
  • Workers: Execute query stages in parallel using pipelined execution. Workers stay running between queries, eliminating cold-start latency.

This model is fundamentally different from Spark, which provisions executors on demand. Trino's always-on workers deliver instant response times, at the cost of holding compute resources continuously.

Supported catalogs​

Trino in Ilum is preconfigured to use:

Trino's connector framework supports many additional sources (PostgreSQL, MySQL, MongoDB, Elasticsearch, Kafka). These can be added through the Trino catalog configuration in Helm values.

संरूपण ​

Enable Trino through the umbrella Helm chart:

ट्रिनो : 
  सक्षम :  सच्चा 
  कैटलॉग : 
    इलम-डेल्टा :  | 
कनेक्टर नाम = delta_lake 
      hive.metastore.uri=thrift://ilum-hive-metastore:9083
      fs.native-s3.enabled=true
      s3.endpoint=http://ilum-minio.ilum-minio:9000
      s3.region=us-east-1
      s3.path-style-access=true
      s3.aws-access-key=minioadmin
      s3.aws-secret-key=minioadmin

Refer to the Production Deployment page for the full reference, including additional connector examples and TLS configuration.

Selecting Trino in the SQL Editor​

In the Ilum SQL Editor, the Engine Selector dropdown lets you choose Trino for any query. Engine status indicators show coordinator and worker health in real time.

When the automatic engine router is enabled, Trino is selected automatically for queries that match its profile (interactive analytics on medium-to-large data).

JDBC and ODBC access​

Trino is reachable through standard JDBC/ODBC interfaces via the Kyuubi gateway, which makes it the preferred engine for connecting Tableau, PowerBI, Superset, and other BI tools to the lakehouse.

संदर्भ लें झांकी एकीकरण और PowerBI Integration for connector setup.

Last updated on