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.
N/A
Terracotta
Score10 out of 10
N/A
Terracotta from German company Software AG presents a database management and development solution.
N/A
Pricing
PrestoDB (or Presto)
Terracotta
Editions & Modules
No answers on this topic
No answers on this topic
Offerings
Pricing Offerings
PrestoDB (or Presto)
Terracotta
Free Trial
No
No
Free/Freemium Version
No
No
Premium Consulting/Integration Services
No
No
Entry-level Setup Fee
No setup fee
No setup fee
Additional Details
—
—
More Pricing Information
Features
PrestoDB (or Presto)
Terracotta
Database Development
Comparison of Database Development features of PrestoDB (or Presto) and Terracotta
Feature
PrestoDB (or Presto)
-
Ratings
Terracotta
10.0
2 Ratings
16% above category average
Version control tools
00 Ratings
10.02 Ratings
Test data generation
00 Ratings
10.02 Ratings
Performance optimization tools
00 Ratings
10.02 Ratings
Schema maintenance
00 Ratings
10.02 Ratings
Database change management
00 Ratings
10.02 Ratings
Database Administration
Comparison of Database Administration features of PrestoDB (or Presto) and Terracotta
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
A de minimis incentive was given to thank the reviewer for their time. The incentive was not used to bias or drive a particular response, nor was the incentive contingent on a positive endorsement. More Info
Magnificent for data virtualization. Terrific to reduce infrastructure cost on IT operations. Excellent with workflow management. Great with data configuration and on-premise installation. Fabulous with data warehousing.
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.
A de minimis incentive was given to thank the reviewer for their time. The incentive was not used to bias or drive a particular response, nor was the incentive contingent on a positive endorsement. More Info
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.
A de minimis incentive was given to thank the reviewer for their time. The incentive was not used to bias or drive a particular response, nor was the incentive contingent on a positive endorsement. More Info
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.
A de minimis incentive was given to thank the reviewer for their time. The incentive was not used to bias or drive a particular response, nor was the incentive contingent on a positive endorsement. More Info
Super friendly and responsive customer service. Reliable and consistent with data management. Great with data visualization. Efficient with data replication.
A de minimis incentive was given to thank the reviewer for their time. The incentive was not used to bias or drive a particular response, nor was the incentive contingent on a positive endorsement. More Info
A de minimis incentive was given to thank the reviewer for their time. The incentive was not used to bias or drive a particular response, nor was the incentive contingent on a positive endorsement. More Info