TrustRadius: an HG Insights company

Save this comparison

Save this comparison

Add Product

Recommended Comparisons

    Overview
    ProductRatingMost Used ByProduct SummaryStarting Price

    Azure HDInsight

    Score8.7 out of 10
    N/AHDInsight is an implementation of the Apache Hadoop technology stack on the Microsoft Azure cloud platform: It is based on the Hortonworks Hadoop distribution. Microsoft Azure HDInsight includes implementations of Apache Spark, HBase, Storm, Pig, Hive, Sqoop, Oozie, Ambari, etc. It also integrates with with business intelligence (BI) tools such as Power BI, Excel, SQL Server Analysis Services, and SQL Server Reporting Services.N/A

    PrestoDB (or Presto)

    Score10 out of 10
    N/APresto 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
    Azure HDInsightPrestoDB (or Presto)
    Editions & Modules
    No answers on this topic
    No answers on this topic
    Offerings
    Pricing Offerings
    Azure HDInsightPrestoDB (or Presto)
    Free Trial
    NoNo
    Free/Freemium Version
    NoNo
    Premium Consulting/Integration Services
    NoNo
    Entry-level Setup FeeNo setup feeNo setup fee
    Additional Details——
    More Pricing Information
    Community Pulse
    Azure HDInsightPrestoDB (or Presto)
    Considered Both Products
    Microsoft
    No answer on this topic
    Open Source
    No answer on this topic
    Key User Insights
    Would buy again
    80%
    Would buy again
    4 Answers
    No answers on this topic
    Delivers good value for the price
    80%
    Delivers good value for the price
    4 Answers
    No answers on this topic
    Happy with the feature set
    80%
    Happy with the feature set
    4 Answers
    No answers on this topic
    Lived up to sales and marketing promises
    No answers on this topic
    No answers on this topic
    Implementation went as expected
    No answers on this topic
    No answers on this topic
    Best Alternatives
    Azure HDInsightPrestoDB (or Presto)
    Small Businesses
    No answers on this topic
    Amazon RDS
    Score8.1 out of 10
    Medium-sized Companies
    Cloudera Manager (no longer available standalone)
    Score9.9 out of 10
    SingleStore
    Score8.2 out of 10
    Enterprises
    Hadoop
    Score7.5 out of 10
    SAP IQ
    Score5.4 out of 10
    All AlternativesView all alternativesView all alternatives
    User Ratings
    Azure HDInsightPrestoDB (or Presto)
    Likelihood to Recommend
    4.0
    (6 ratings)
    7.8
    (2 ratings)
    Usability
    8.9
    (4 ratings)
    -
    (0 ratings)
    Support Rating
    1.0
    (5 ratings)
    -
    (0 ratings)
    User Testimonials
    Azure HDInsightPrestoDB (or Presto)
    Likelihood to Recommend
    Microsoft
    Well suited: A tiny-mid sized company with no immediate plans of growing the volume of their data processing, that can afford long response times from support. Also it helps if you are not prone to put your hands on Linux and Spark configuration. In fact, it can make things go really faster if you also work with the bundle-in Jupyter. And, if you need to perform some diagnostics and / or administrative tasks, that's full of tools to find an understand the Root Cause. Ideal for non experts. Less appropriate: Big Data company, intense on demand cluster creation, mission critical, costs reduction, latest versions of libraries required, sophisticate customizations required.
    Incentivized
    Read full review
    Open Source
    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
    Incentivized
    Read full review
    Pros
    Microsoft
    • Data is presented without interfering others (IT or other dept).
    • Data is managed properly and is available for retrievable any time.
    • Legacy use of CD/DVD and Pendrive are not required.
    Incentivized
    Read full review
    Open Source
    • 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.
    Incentivized
    Read full review
    Cons
    Microsoft
    • The only problem I have come across is when loading large volumes of data I sometimes get an error message, I assume this means something is corrupt from within. I would love a way for this to be resolved without having to start over.
    Incentivized
    Read full review
    Open Source
    • 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.
    Incentivized
    Read full review
    Usability
    Microsoft
    Azure HDInsight is usable on the top of Azure Data Lake and gives us the benefit of analyzing large scale data workload in Hadoop. Usability and support from Microsoft are outstanding.
    Incentivized
    Read full review
    Open Source
    No answers on this topic
    Support Rating
    Microsoft
    Inexpert, isolated teams... not good for support an excessively complex platform. Lots of weeks or months for a complex problem troubleshoot. Many time lost stuck on MindTree, before the case was finally escalated with Microsoft!
    Incentivized
    Read full review
    Open Source
    No answers on this topic
    Alternatives Considered
    Microsoft
    At this time I have not used any other similar products... I am open to it but Azure HDInsight and its components really work well for our organization.
    Incentivized
    Read full review
    Open Source
    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.
    Incentivized
    Read full review
    Return on Investment
    Microsoft
    • ROI is of course there, as no legacy software for data presentation.
    • No manual intervention for data retrieval.
    • Data is available anywhere as requested.
    Incentivized
    Read full review
    Open Source
    • 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.
    Incentivized
    Read full review
    ScreenShots