Top all-time · #1486
Altinity
Company blog · altinity.com/blogdatasystems
Altinity is the company blog at altinity.com, writing about data and systems. Since 2018, 49 different Hacker News readers have linked it 110 times, most often “Clickhouse-local: The power of ClickHouse SQL in a single command”. It is still writing: the last post was on 2026-11-02, and you can follow it by feed.
Rarely recommended · 2 of 38 sampled comments recommend it?
Why HN links it
HN readers cite Altinity's blog as a source on ClickHouse internals, including clickhouse-local, column codecs, dictionaries, and benchmarks. It also covers its managed ClickHouse services.
Summarised by Claude from a sample of 38 HN comments that link here. Each comment is marked recommending, critical or neutral (citing without judging); how this works.
Build ClickHouse-based analytics applications that detect, analyze, and leverage real-time insights for any use case in any environment.
Most-linked posts?
- /blog/2019/7/new-encodings-to-improve-clickhouse5 people · 5 mentions · first linked 2021-02-19
- Clickhouse-local: The power of ClickHouse SQL in a single command4 people · 5 mentions · first linked 2019-06-12
- ClickHouse for Time Series4 people · 4 mentions · first linked 2018-11-20
- /blog/clickhouse-for-time-series3 people · 3 mentions · first linked 2021-05-05
- Reflections on Embedding ClickHouse in Firebolt3 people · 3 mentions · first linked 2022-01-19
- ClickHouse nails cost efficiency challenge against Druid and Rockset3 people · 3 mentions · first linked 2021-03-13
- Making Data Come to Life with ClickHouse Live View Tables3 people · 3 mentions · first linked 2019-11-14
- OSACon 2021: Free Open Source and Analytics Online Conference2 people · 4 mentions · first linked 2021-09-15
- /blog/2019/6/11/clickhouse-local-the-power-of-clickhouse-sql-in-a-single-command2 people · 3 mentions · first linked 2021-03-13
- /cloud-database/2 people · 2 mentions · first linked 2021-05-28
What Hacker News says?
Altinity | Multiple ClickHouse engineering positions | REMOTE in North America and Europe| Full-time | Competitive Salary and Equity Hello! We are Altinity, a fast-growing database startup with a distributed team spanning from California to Eastern Europe. Our business is to make customers successful with ClickHouse, the leading open source data warehouse. Our customers range from ambitious startups to some of the m…
Comment linking /careers
on “Ask HN: Who is hiring right now?”Submitted ClickHouse cost-efficiency in action: analyzing 500B rows on an Intel NUC as a story · 216 points
HN discussionClickHouse has lambdas for arrays. They are very useful. Here's an example. WITH ['a', 'bc', 'def', 'g'] AS array SELECT arrayFilter(v -> (length(v) > 1), array) AS filtered ┌─filtered─────┐ │ ['bc','def'] │ └──────────────┘ The lambda in this case is a selector for strings with more than one character. I would not argue that they are as general as Pandas, but they are might useful. More examples from the following…
Comment linking /blog/harnessing-the-power-of-clickhouse-arrays-part-2
on “Practical SQL for Data Analysis”Submitted Migrating from Redshift to ClickHouse as a story · 73 points
HN discussionAltinity | Multiple ClickHouse & Cloud engineering positions | REMOTE in North America and Europe| Full-time | Competitive Salary and Equity Hello! We are Altinity, a fast-growing database startup with a distributed team spanning from California to Eastern Europe. Our business is to make customers successful with ClickHouse, the leading open source data warehouse. Our customers range from ambitious startups to some…
Comment linking /careers
on “Ask HN: Who is hiring? (August 2020)”Submitted ClickHouse Is Apache 2.0 as a story · 17 points
HN discussionAltinity | Multiple ClickHouse engineering positions | REMOTE in North America and Europe| Full-time | Competitive Salary and Equity Hello! We are Altinity, a fast-growing database startup with a distributed team spanning from California to Eastern Europe. Our business is to make customers successful with ClickHouse, the leading open source data warehouse. Our customers range from ambitious startups to some of the m…
Comment linking /careers
on “Ask HN: Who is hiring? (May 2020)”Submitted I There Future for Databases Beyond the Cloud? as a story · 14 points
HN discussionFor example, you can use ClickHouse queries to dynamically change the shape of pages based on user behavior across multiple sites (aka retargeting). You can can also use ClickHouse to manage CDN downloads in real time. Here are a couple of talks that illustrate both use cases. We still call this OLAP but it's quite different from traditional uses. In particular the core data come event streams. https://altinity.com/…
Comment linking /webinarspage/2020/6/23/big-data-and-beautiful-video-how-clickhouse-enables-mux-to-deliver-content-at-scale
on “ClickHouse, Inc.”Submitted ClickHouse for Time Series as a story · 12 points
HN discussionAiven will offer a managed Clickhouse service too: https://landing.aiven.io/2020-upcoming-aiven-services-webina... And also Altinity is a trustable partner with a great know-how about Clickhouse internals. They have started to offer managed instances in AWS: https://altinity.com/altinity-cloud-test-drive/ At last, Alibaba Cloud has an option to use: https://www.alibabacloud.com/product/clickhouse Are there any other…
Comment linking /altinity-cloud-test-drive/
on “ClickHouse, Inc.”Submitted What We Learned by Closing a $4M Investment from Accel as a story · 11 points
HN discussionI wonder how this will play out with https://altinity.com who have been doing enterprise support for quite some time..
Comment linking /
on “ClickHouse, Inc.”Submitted Unraveling the Mystery of Idle Threads in ClickHouse as a story · 6 points
HN discussionI would have thought better compression was one, but it looks like Clickhouse now supports all the time series-optimized encodings like delta and gorilla - https://altinity.com/blog/2019/7/new-encodings-to-improve-cl... .
Comment linking /blog/2019/7/new-encodings-to-improve-clickhouse
on “Show HN: SigNoz – open-source alternative to DataDog, NewRelic”Submitted Reflections on Embedding ClickHouse in Firebolt as a story · 5 points
HN discussionYou could try Clickhouse. It's a bit heavier than DuckDB and the default mode is server-client. But you can also use the client (a single binary) without a server to directly query data from csv or parquet files. edit: added a better link, the stand-alone mode is called clickhouse-local https://clickhouse.tech/docs/en/interfaces/cli https://altinity.com/blog/2019/6/11/clickhouse-local-the-pow...
Comment linking /blog/2019/6/11/clickhouse-local-the-power-of-clickhouse-sql-in-a-single-command
on “What's New in SQLite 3.35”Submitted Database on Fire: Reflections on Embedding ClickHouse in Firebolt as a story · 5 points
HN discussion> TSDB please work on allowing us to put data over 1 year old on slow disk seperate servers, so we can keep the hot stuff on the NVME servers, once you get this sorted it will be the perfect fit for us. ClickHouse recently added multi-volume storage for exactly the use case you describe. [1] It's a great feature. [1] https://www.altinity.com/blog/2019/11/27/amplifying-clickhou...
Comment linking /blog/2019/11/27/amplifying-clickhouse-capacity-with-multi-volume-storage-part-1
on “Multi-node TimescaleDB is now free”Submitted Clickhouse Is Apache 2.0 as a story · 5 points
HN discussionThat's a good question! Especially considering these overwhelming benchmarks [1] made via Timescale TSBS [2]. [1] https://www.altinity.com/blog/clickhouse-for-time-series [2] https://github.com/timescale/tsbs
Comment linking /blog/clickhouse-for-time-series
on “Multi-node TimescaleDB is now free”Submitted Too Wide or Not Too Wide – That Is the ClickHouse Question as a story · 4 points
HN discussionWorth to note clickhouse-local: full featured ClickHouse SQL engine for files in CSV/TSV/JSONLines, whatever... https://www.altinity.com/blog/2019/6/11/clickhouse-local-the...
Comment linking /blog/2019/6/11/clickhouse-local-the-power-of-clickhouse-sql-in-a-single-command
on “TSV Utilities: Command line tools for large, tabular data files”Submitted ClickHouse Object Storage Performance Benchmarking: MinIO vs. AWS S3 as a story · 4 points
HN discussionMy apologies. Here is the correct URL. It's the ClickHouse web UI. https://github.demo.trial.altinity.cloud:8443/play?user=demo For instructions on use, check out the following blog article. https://altinity.com/blog/connecting-to-altinity-cloud-with-...
Comment linking /blog/connecting-to-altinity-cloud-with-the-clickhouse-web-ui
on “Southwest operational meltdown as hundreds of flights canceled or delayed”Submitted ClickHouse nails cost efficiency challenge against Druid and Rockset as a story · 4 points
HN discussionAltinity | Multiple ClickHouse engineering positions | REMOTE in North America and Europe| Full-time | Competitive Salary and Equity Hello! We are Altinity, a fast-growing database startup with a distributed team spanning from California to Eastern Europe. Our business is to make customers successful with ClickHouse, the leading open source data warehouse. Our customers range from ambitious startups to some of the m…
Comment linking /careers
on “Ask HN: Who is hiring? (March 2020)”Submitted ClickHouse and Redshift Face Off Again in NYC Taxi Rides Benchmark as a story · 4 points
HN discussionYes to both, Altinity maintains the ClickHouse Grafana plugin https://altinity.com/blog/2019/12/28/creating-beautiful-graf... And Superset has a recommendation of a ClickHouse connector https://superset.apache.org/docs/databases/clickhouse
Comment linking /blog/2019/12/28/creating-beautiful-grafana-dashboards-on-clickhouse-a-tutorial
on “ClickHouse as an alternative to Elasticsearch for log storage and analysis”Submitted Handling Real-Time Updates in ClickHouse as a story · 4 points
HN discussion
