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
