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 Read full review I cannot imagine where Tibero will be less appropriate. For anyone looking for a reliable RDBM software, I suggest reviewing Tibero's data sheet for more details of its features and decide for yourself, if this software would work best for your organization.
Read full review 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. Read full review Robustness Feature set Security Cost Read full review 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. Read full review Working with Tibero for the last 5 years, I haven't noticed any issues so far. Read full review 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.
Read full review As for features it's more or less the same with lower licensing fees, if you are running on either of the bigger DB providers and you want to port over your data they can do it for you. We chose it after reviewing about 10 different DB providers but didn't want to go with open source.
Read full review 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. Read full review Because Tibero's licensing and support fees are half of Oracle's, we were able to allocate the extra budget to other departments that were in greater need for those funds. Read full review ScreenShots