<story><title>Clickhouse Local</title><url>https://clickhouse.tech/docs/en/operations/utils/clickhouse-local/</url></story><parent_chain><item><author>georgewfraser</author><text>Why do people on HN love Clickhouse so much? As far as I can tell, it’s an ordinary column store, with a bunch of limitations around distributed joins and a heuristic-based query planner. There are several good analytical databases that will give you the same scan performance and a much better query planner and executor.&lt;p&gt;This is not a rhetorical question, I would really like to know why it gets so much attention here.</text></item></parent_chain><comment><author>bsg75</author><text>Its somewhat unique in the open source category.&lt;p&gt;As a column store engine that supports (hybrid) SQL, manages its own storage and clustering, and has only one external dependency (Zookeeper), I believe its main competitor is Vertica which can be very expensive. I assume Oracle, IBM, and MS have column stores as well and for a cost.&lt;p&gt;Greenplum is a Postgres fork, and same scale requires much more hardware. Citus is row based, and therefore will lag in scan time for many OLAP query patterns. Presto, Hive, Spark, all of the &amp;quot;post-hadoop&amp;quot; options may scale larger, but will also lag in scan time, and have significant external dependencies - mainly storage.&lt;p&gt;Clickhouse is easy to install, configure a cluster, load and query. It does have limitations, but currently all horizontally scaled database platforms do.</text></comment>
<story><title>Clickhouse Local</title><url>https://clickhouse.tech/docs/en/operations/utils/clickhouse-local/</url></story><parent_chain><item><author>georgewfraser</author><text>Why do people on HN love Clickhouse so much? As far as I can tell, it’s an ordinary column store, with a bunch of limitations around distributed joins and a heuristic-based query planner. There are several good analytical databases that will give you the same scan performance and a much better query planner and executor.&lt;p&gt;This is not a rhetorical question, I would really like to know why it gets so much attention here.</text></item></parent_chain><comment><author>atombender</author><text>Because it&amp;#x27;s one of the few mature, fast, scalable analytics-oriented databases that is also completely open source.&lt;p&gt;The closest open source thing that matches its feature set is Presto, but that one is quite different.&lt;p&gt;Apache Druid is supposed to be very mature, but also very difficult to set up and manage. I&amp;#x27;ve not used it myself.&lt;p&gt;There&amp;#x27;s also Vespa, but I don&amp;#x27;t know how well it performs with large numbers of columns.&lt;p&gt;A lot of people use Elasticsearch for analytics. Being based on Lucene, it&amp;#x27;s &lt;i&gt;kind of&lt;/i&gt; columnar, and it can perform very well indeed on aggregations.&lt;p&gt;InfluxDB may be good, but it&amp;#x27;s not fully open source.</text></comment>