What users are saying about
5 Ratings
2 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
2 Ratings
<a href='https://www.trustradius.com/static/about-trustradius-scoring' target='_blank' rel='nofollow noopener'>trScore algorithm: Learn more.</a>
Score 7 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.0

Valentina

70%
1 Rating

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

Paradigma Software

If you have to manage a lot of different databases from different vendors, you could do well by standardizing on this product. It checks all the boxes for a proper database management studio. You would only have to learn one product to manage them all. However, if you are looking to find a good product for a single database vendor, you might be better off finding a tool that was designed specifically for that vendor product.
Read full review

Pros

Yandex

  • Opensource
  • High performance
  • Multiple engines to adapt user cases
  • Easy configuration of data replication
Read full review

Paradigma Software

  • Foreign Key Constraint data viewer! This was a tremendously helpful feature that not many other products have. Just pick a constraint and see the data in the child tables! No setup required!
  • Supports any and every database imaginable.
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

Paradigma Software

  • Somewhat laggy performance. Boot up speed was on the slow side and connecting to our database servers was also a little slower than other products.
  • User interface can be a little clunky. Instead of the usual tree view of servers, databases, and schemas, you are presented with lists that you click on and get new windows to pick the new list of data from. Not organized efficiently.
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

    Valentina

    Starting Price

    $0

    Editions & Modules

    Valentina 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

      Paradigma Software

      Compared to Microsoft's SQL Management Studio, Valentina studio was comparable, just harder to get used to in the UI department. It ran slightly slower than other products but did save some time with neat features they baked into the product. However, in using DBeaver Community and DBForge Studio for PostgreSQL from Devart, we found different products that the team ultimately decided to use. DBeaver has all of the features we needed most (minus the constraint data viewer) and a more intuitive UI that we were used to. DBForge Studio for PostgreSQL has a very standard Windows look and feel and lacks some features, like database/table designers, but makes up for those shortcomings in the much easier filtering and sorting options right in the data grids. You can even write a query and edit the data returned, which is something we don't see in many of these tools. Our team ultimately settled on the developers using DBeaver and the support team that needs data viewing/editing capabilities using DBForge Studio.
      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

      Paradigma Software

      • It saved time in some areas of finding child data by not having to write queries to find it.
      • The user interface caused some extra training for some users and ultimately caused them to not like using it.
      Read full review

      Add comparison