Skip to main content
TrustRadius
Presto

Presto
Formerly Presto DB

Overview

What is Presto?

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.

Read more

Learn from top reviewers

Why do we Presto

Rating: 8 out of 10
August 8, 2017
IncentivizedVetted ReviewVerified User
Presto is used at Uuber for ad-hoc querying on datasets and also for a few data driven applications. It is used across the entire organization to make data driven decisions, r...
Continue reading
Praveen Murugesan
Manager - Engineering
Engineering Manager - Ride Experience
Uber
Presto2 years of experience

Presto Review for Insider (Gannett)

Rating: 7 out of 10
March 23, 2017
IncentivizedVetted ReviewVerified User
Presto is used as our story publisher via The Des Moines Register and Gannett sites. We build, edit, and design story layout and publish to our website. My Marketing Group mai...
Continue reading
Corinne Nacin-Martinez
Manager - Marketing
Consumer Sales & Sevice Manager
Gannett
Presto1 year of experience
Log in with LinkedIn to see content from your network
Return to navigation

Pricing

View all pricing
Presto

Presto

N/A
Unavailable

What is Presto?

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.

Entry-level set up fee?

  • No setup fee

Offerings

  • Free Trial
  • Free/Freemium Version
  • Premium Consulting/Integration Services

Would you like us to let the vendor know that you want pricing?

7 people also want pricing

Alternatives Pricing

Amazon RDS

Amazon RDS

N/A
Unavailable
What is Amazon RDS?

Amazon Relational Database Service (Amazon RDS) is a database-as-a-service (DBaaS) from Amazon Web Services.

TeamDesk

TeamDesk

$49
5 users included
What is TeamDesk?

TeamDesk is a low-code development platform for online database creation. Business owners or managers can build a unique web database solution without any programming to facilitate working with data, organize routine work and create an accessible data source for teams.

Return to navigation

Product Demos

SIGNORA PRESTO LISTRIK DEMO 6 (OFFICIAL VIDEO 2013)

YouTube

SIGNORA PRESTO LISTRIK DEMO 2 (OFFICIAL VIDEO 2013)

YouTube

はつゆきさくら DEMO ムービー （2012 サガプラネッツ、主題歌:I've・歌:KOTOKO、ムービー:ろど）

YouTube

Ultima Cosa Presto Luxe Plus 5L Air Fryer Unboxing and Testing Demo Review 2020 | XKUBE Connects

YouTube

Presto 6 Cup Stainless Steel Coffee Maker Demo

YouTube

Presto Knife Sharpener (08810) Review & Demo

YouTube
View more demos
Return to navigation

Product Details

What is Presto?

Presto Video

Planificación y realidad. Diagrama de barras. Puede solicitrar más información en https://www.rib-software.es/pages/info.htm

Presto Technical Details

Operating SystemsUnspecified
Mobile ApplicationNo
Return to navigation

Comparisons

View all alternatives
Return to navigation

Reviews From Top Reviewers

Community Insights

TrustRadius Insights are summaries of user sentiment data from TrustRadius reviews and, when necessary, 3rd-party data sources. Have feedback on this content? Let us know!

Fast Data Delivery: Many users have been amazed by the superfast query response of Presto, indicating its highly efficient handling of data queries.

Flexible Data Access: Users appreciate the flexibility of Presto in adapting to query translations and connecting with multiple data sources like HIVE and MySQL. This wide range of options for accessing and analyzing different types of data is highly valued by reviewers.

User-Friendly Interface: Reviewers find Presto to be a well-known SQL engine in the database industry, highlighting its organization and ease of querying data objects. The user-friendly interface and SQL syntax make it easy for users to work with Presto.

Complexity with ElasticSearch DB integration: Some users have found Presto to be complex when dealing with ElasticSearch DB and translating it into stat. They have reported difficulties in understanding the process and navigating through it.

Difficulty in finding all products: Several reviewers have mentioned that it is challenging to locate all their products in Presto. This has caused frustration and inefficiency when trying to access specific items within the platform.

Limitations with drop and delete statements: Users have expressed frustration over the limitations of drop and delete statements in Presto, making it difficult for them to rely solely on the platform for end-to-end work. These limitations have hindered their ability to efficiently manage and manipulate data within Presto.

View all reviews
(1-2 of 2)

Presto Review for Insider (Gannett)

Rating: 7 out of 10
Incentivized
March 23, 2017
Use Cases and Deployment Scope
Presto is used as our story publisher via The Des Moines Register and Gannett sites. We build, edit, and design story layout and publish to our website. My Marketing Group mainly uses Presto for our Insider program - this is a template of offers, deals & events exclusively for our subscribers.
Pros
  • 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.
Cons
  • 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.
Likelihood to Recommend
Simple stories & templates work nicely - like for our Insider program.

Stories that include a lot of images may be challenging to create & have look appealing.
Return on Investment
  • Our Insider program continues to grow - Presto is definitely not a hinderance.
  • Gannett corporate pays for the Presto services for all of the Gannett Newspaper sites - i have no input on ROI.
  • We do not use Presto to gain NEW subscribers.
Alternatives Considered
Presto is good for a templated design appeal. You cannot be too creative via this interface - but, the layout and options make the finalized visual product appealing to customers. The other design products I use are for different purposes and not really comparable to Presto.
Other Software Used

Why do we Presto

Rating: 8 out of 10
Incentivized
August 08, 2017
PM
Praveen Murugesan
Engineering Manager - Ride Experience
Uber (Internet, 5001-10,000 employees)
Vetted Review
Verified User
Presto
2 years of experience
View profile
Use Cases and Deployment Scope
Presto is used at Uuber for ad-hoc querying on datasets and also for a few data driven applications. It is used across the entire organization to make data driven decisions, reporting, experimentation analysis etc. Presto provides a scalable, fast distributed query engine and we use it on top of HDFS.
Pros
  • 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.
Cons
  • 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.
Likelihood to Recommend
Presto is for interactive simple queries, where Hive is for reliable processing. If you have a fact-dim join, presto is great..however for fact-fact joins presto is not the solution.. Presto is a great replacement for proprietary technology like Vertica.
Return on Investment
  • Presto has helped scale Uber's interactive data needs. We have migrated a lot out of proprietary tech like Vertica.
  • Presto has helped build data driven applications on its stack than maintain a separate online/offline stack.
  • Presto has helped us build data exploration tools by leveraging it's power of interactive and is immensely valuable for data scientists.
Alternatives Considered
I think Presto is one of the best solutions out there today at the cutting edge for interactive query analysis. One of the challenges is presto is a niche tool for the interactive query use case and doesn't have the knobs and whistles as much as Spark. In the foreseeable future if they are able to make presto work without the need for Hive, solving all the gaps it could be game changing and can be a direct threat to spark.
Other Software Used
Return to navigation