Leaving a video review helps other professionals like you evaluate products. Be the first one in your network to record a review of Presto, and make your voice heard!
Entry-level set up fee?
- No setup fee
- Free Trial
- Free/Freemium Version
- Premium Consulting / Integration Services
Would you like us to let the vendor know that you want pricing?
Presto is an open source SQL query engine designed to run queries on data stored in Hadoop or in traditional databases.
Teradata supported development of Presto followed the acquisition of Hadapt and Revelytix.
- Fast - Presto, is incredibly fast due to its optimized query engine and is well suited for interactive analysis.
- Flexible - Presto is highly flexible as it operates with a plug and play model for data sources. Joining and query across different data sources is very easy with presto (eg. HDFS, MySQL, Kafka).
- ANSI Sql - Presto follows ANSI SQL which is the recognized SQL language and hence helps allow easy query migration without much overhead.
- Large Fact + Small Dimension table joins made fast - By design presto excels most distributed query engines out there in this type of queries.
- Presto was not designed for large fact fact joins. This is by design as presto does not leverage disk and used memory for processing which in turn makes it fast.. However, this is a tradeoff..in an ideal world, people would like to use one system for all their use cases, and presto should get exhaustive by solving this problem.
- Resource allocation is not similar to YARN and presto has a priority queue based query resource allocation..so a query that takes long takes longer...this might be alleviated by giving some more control back to the user to define priority/override.
- UDF Support is not available in presto. You will have to write your own functions..while this is good for performance, it comes at a huge overhead of building exclusively for presto and not being interoperable with other systems like Hive, SparkSQL etc.
- Linking, embedding links and adding images is easy enough.
- Once you have become familiar with the interface, Presto becomes very quick & easy to use (but, you have to practice & repeat to know what you are doing - it is not as intuitive as one would hope).
- Organizing & design is fairly simple with click & drag parameters.
- HCI - Intuitively there are quite a few design elements I was unsure of before I got enough practice.
- Curating Fronts - should have an auto-organize element so you don't need to move each front.
- Save, Publish & Unpublish options should be easier to understand.
- Presto should have a copy feature.