What users are saying about
5 Ratings
18 Ratings
5 Ratings
<a href='https://www.trustradius.com/static/about-trustradius-scoring' target='_blank' rel='nofollow noopener'>trScore algorithm: Learn more.</a>
Score 9.3 out of 100
18 Ratings
<a href='https://www.trustradius.com/static/about-trustradius-scoring' target='_blank' rel='nofollow noopener'>trScore algorithm: Learn more.</a>
Score 6 out of 100

Attribute Ratings

  • ClickHouse is rated higher in 1 area: Likelihood to Recommend

Likelihood to Recommend

9.0

ClickHouse

90%
2 Ratings
7.8

Presto

78%
2 Ratings

Likelihood to Recommend

Yandex

1) An extensive SQL syntax. A lot of functions are included (including GeoDistances, Uber Hexagons, time functions, comprehensive Mah, and many others). Several functions can be combined (e.g. SumIf, AvgIf, etc.) which is very convenient. 2) It is quick. The arrays and MapReduce make CH work lightning fast. I was extremely surprised when several GBs of data were processed in less than a second. 3)A fast response time. Using Materialized Views correctly allows instant processing of TBs of data, which works differently than in other databases. 4)This is an efficient process. It is possible to store data extremely efficiently by using a wide range of data types and compression algorithms. Choose the best compression type for your tables based on the documentation. There will be a lot of surprises for you.
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
Read full review

Pros

Yandex

  • Opensource
  • High performance
  • Multiple engines to adapt user cases
  • Easy configuration of data replication
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.
Read full review

Cons

Yandex

  • Unable to make custom functions
  • So many times it required to use multiple joins
  • I faced a lot of problems with Zookeeper, Partitioning, Sharding, and replication.
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.
Read full review

Pricing Details

ClickHouse

Starting Price

Editions & Modules

ClickHouse editions and modules pricing
EditionModules

Footnotes

    Offerings

    Free Trial
    Free/Freemium Version
    Premium Consulting/Integration Services

    Entry-level set up fee?

    No setup fee

    Additional Details

    Presto

    Starting Price

    Editions & Modules

    Presto editions and modules pricing
    EditionModules

    Footnotes

      Offerings

      Free Trial
      Free/Freemium Version
      Premium Consulting/Integration Services

      Entry-level set up fee?

      No setup fee

      Additional Details

      Alternatives Considered

      Yandex

      ClickHouse was not compared to them as a competitor but as the ideal partner to complete an information analysis system, providing users with the most complete and efficient tools. Therefore, in this case it was considered that it would be the ideal candidate due to its characteristics compared to the other competitors.
      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.
      Read full review

      Return on Investment

      Yandex

      • It help our software to run with more and more amount of monitors.
      • Very easy to working while DR-DC scenario happened at client side.
      • Structured of DB with column-oriented data help a lot to reducing I/O of that server.
      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.
      Read full review

      Add comparison