Watsonx.data is presented as an open, hybrid and governed data store that makes it possible for enterprises to scale analytics and AI with a fit-for-purpose data store, built on an open lakehouse architecture, supported by querying, governance and open data formats to access and share data.
N/A
Presto
Score 2.6 out of 10
N/A
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
Pricing
IBM watsonx.data
Presto
Editions & Modules
No answers on this topic
No answers on this topic
Offerings
Pricing Offerings
IBM watsonx.data
Presto
Free Trial
Yes
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
Community Pulse
IBM watsonx.data
Presto
Considered Both Products
IBM watsonx.data
Verified User
Partner
Chose IBM watsonx.data
with iceberg open table format and Presto engine the performance and flexibility increased and also with watsonx.ai with GENAI capability which other tools lag as of now.
IBM watsonx.data is well suited for use cases were you have to combine various data sources to build a lakehouse. It provides a secure framework to gather data and provide access to it to build ML/AI models. It allows users to focus on prompts and business logic than spend time on data engineering.
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
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.
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.
I can give it 10/10 due to its impact in data analysis management. This is the right software for driving business insights and enhancing effective decision making. The infrastructure has the formal tools for preparing data before using it to make critical decisions. The NLP has enhanced standard analysis of unstructured data from social media websites.
IBM watsonx.data has great capabilities on multiple data easy accessibility and easy to extract data and sharing to various platforms. The IBM watsonx.data still offers effective data protection and the ability to manage large amount of business data from one piont is productive. Data warehousing capability is another implortant of using IBM watsonx.data and helpful of real time analytics production.
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.