Announcing public preview of Trino with Azure HDInsight on AKS

  • Thread starter Thread starter sairamyeturi
  • Start date Start date
S

sairamyeturi

Author: Abhishek Jain, Senior Product Manager



We are excited to announce the public preview of Trino with HDInsight on AKS.

Trino is an open-source distributed SQL query engine for federated and interactive analytics against heterogeneous data sources.
It is highly performant and scalable when it comes to both structured and unstructured data. It can query data at scale (gigabytes to petabytes) from multiple sources to enable enterprise-wide analytics.

Use cases of Trino:
Trino is used for a wide range of analytical use cases. Some of them include:

  1. Interactive and ad-hoc querying.
  2. Federated querying across data sources in the same query without moving the data to a single location.
  3. Batch ETL across heterogenous systems.
  4. Reporting and Dashboarding.

Benefits
Trino on HDInsight on AKS supports most of the features available in OSS version of Trino. In addition, we have added some exciting and exclusive features:



Exclusive features:
​

  1. Trino Power BI connector: Much awaited feature is finally available. An inbuilt Power BI connector to connect with Trino cluster and build super cool dashboards.
  2. Result caching: Makes subsequent execution of your queries faster. It works for all connectors and can be configured easily using Azure portal.
  3. Query scan statistics on Trino UI: This feature allows users to capture Scan statistics for any connector enabling them to investigate performance or optimize queries.
  4. Log query events on ADLS Gen2: An inbuilt plugin that log events in ADLS Gen2 enabling custom logging, debugging and performance analysis.

Additional features:​



  1. Easy to configure cluster: An intuitive UI to tune your Trino cluster using Azure portal.
  2. Auto scale: Scale out the number of nodes based on an anticipated increase in application demand, and then automatically scale in the number of nodes at a time that you anticipate less demand.
  3. Integration with data sources: Add catalogs to your clusters. Check out the connectors.
  4. Monitoring: Easy integration with Azure Monitor, Managed Prometheus and Grafana.
  5. Multiple ways to query Trino cluster: Use Trino CLI, Secure shell using Azure portal, or SQL clients such as DBeaver.

There are many more exciting features on our roadmap. Get started and Stay tuned!

We are super excited to get you started, let's get to how?


Continue reading...
 
Back
Top