TrustRadius: an HG Insights company

Starburst Enterprise

Score10 out of 10

4 Reviews and Ratings

What is Starburst Enterprise?

Starburst Enterprise is a fully supported, production-tested and enterprise-grade distribution of open source Trino (formerly Presto® SQL). It aims to improve performance and security while making it easy to deploy, connect, and manage a Trino environment. Through connecting to any source of data – whether it’s located on-premise, in the cloud, or across a hybrid cloud environment – Starburst provides analytics tools to users while accessing data that lives anywhere.

Categories & Use Cases

Starburst Presto - Track your SQL queries efficiently.

Use Cases and Deployment Scope

We use Starburst Presto to monitor our SQL queries (which ones are running, got stuck, which are taking too much time, how many resources have been allocated to run the query, etc.). It also monitors total active queries, runnable drivers, worker parallelism, and queued queries (if any are present in the system).

Pros

  • Query tracking.
  • Resource allocation.
  • Parallelizing query execution.

Cons

  • Pricing
  • Platform can be made more intuitive.
  • Sometimes the platform hangs while aborting the query.

Most Important Features

  • Query tracking
  • Worker node/resource allocation.
  • Live dashboard to review the query status.

Return on Investment

  • Neutral impact.
  • ROI on saving time for query execution.
  • Parallel processing saves time too.

Alternatives Considered

Amazon EMR (Elastic MapReduce)

Other Software Used

RStudio, Apache Hadoop, Apache Spark