# Blogs

## Apache Pinot Official Blog

Visit the [Apache Pinot Blog](https://pinot.apache.org/blog/) for the latest posts from the Pinot community.

### 2024

* [Apache Pinot Year in Review 2024](https://pinot.apache.org/blog/2024/12/20/apache-pinot-year-in-review-2024/) - Peter Corless (Dec 2024)
* [Pinot for Low-Latency Offline Table Analytics](https://pinot.apache.org/blog/2024/09/03/pinot-for-low-latency-offline-table-analytics/) - Ankit Sultana, Caner Balci, Uber Data Team (Sep 2024)
* [The Power of Apache Pinot: Why I Chose It for Real-Time Analytics](https://pinot.apache.org/blog/2024/09/02/the-power-of-apache-pinot-why-i-chose-it-for-real-time-analytics/) - Unais Yousha Siddiqui (Sep 2024)
* [Build a real-time analytics solution with Apache Pinot on AWS](https://pinot.apache.org/blog/2024/08/07/AWSxPinot/) - Raj Ramasubbu, Francisco Morillo, Ismail Makhlouf (Aug 2024)

### 2023

* [Announcing Apache Pinot 1.0](https://pinot.apache.org/blog/2023/09/19/Annoucing-Apache-Pinot-1-0/) - Hubert Dulay, Mayank Shrivastava, Neha Pawar (Sep 2023)
* [Segment Compaction for Upsert Enabled Tables in Apache Pinot](https://pinot.apache.org/blog/2023/08/04/segment-compaction-for-upsert-enabled-tables-in-apache-pinot-3f30657aa077/) - Robert Zych (Aug 2023)
* [Star-Tree Index in Apache Pinot - Part 3 - Understanding the Impact in Real Customer Scenarios](https://pinot.apache.org/blog/2023/07/12/star-tree-index-in-apache-pinot-part-3-understanding-the-impact-in-real-customer/) - Sandeep Dabade, Kulbir Nijjer (Jul 2023)
* [Real-Time Mastodon Usage with Apache Kafka, Apache Pinot, and Streamlit](https://pinot.apache.org/blog/2023/06/01/real-time-mastodon-usage-with-apache-kafka-apache-pinot-and-streamlit/) - Mark Needham (Jun 2023)
* [How to Ingest Streaming Data from Kafka to Apache Pinot](https://pinot.apache.org/blog/2023/05/30/how-to-ingest-streaming-data-from-kafka-to-apache-pinot/) - Barkha Herman (May 2023)
* [Change Data Capture with Apache Pinot - How Does It Work?](https://pinot.apache.org/blog/2023/05/23/change-data-capture-with-apache-pinot-how-does-it-work/) - Hubert Dulay (May 2023)
* [Apache Pinot Tutorial for Getting Started - A Step-by-Step Guide](https://pinot.apache.org/blog/2023/05/18/apache-pinot-tutorial-for-getting-started-a-step-by-step-guide/) - Barkha Herman (May 2023)
* [StarTree Indexes in Apache Pinot Part-1 - Understanding the Impact on Query Performance](https://pinot.apache.org/blog/2023/05/16/star-tree-indexes-in-apache-pinot-part-1-understanding-the-impact-on-query-performance/) - Sandeep Dabade (May 2023)
* [Geospatial Indexing in Apache Pinot](https://pinot.apache.org/blog/2023/05/11/Geospatial-Indexing-in-Apache-Pinot/) - Mark Needham (May 2023)
* [Apache Pinot 0.12 - Consumer Record Lag](https://pinot.apache.org/blog/2023/03/30/Apache-Pinot-0-12-Consumer-Record-Lag/) - Mark Needham (Mar 2023)
* [Apache Pinot 0.12 - Configurable Time Boundary](https://pinot.apache.org/blog/2023/02/21/Apache-Pinot-0-12-Configurable-Time-Boundary/) - Mark Needham (Feb 2023)
* [Apache Pinot 0.11 - Deduplication on Real-Time Tables](https://pinot.apache.org/blog/2023/01/29/Apache-Pinot-Deduplication-on-Real-Time-Tables/) - Mark Needham (Jan 2023)

### 2022

* [Apache Pinot 0.11 - Pausing Real-Time Ingestion](https://pinot.apache.org/blog/2022/11/28/Apache-Pinot-Pausing-Real-Time-Ingestion/) - Mark Needham (Nov 2022)
* [Apache Pinot 0.11 - Timestamp Indexes](https://pinot.apache.org/blog/2022/11/22/Apache-Pinot-Timestamp-Indexes/) - Mark Needham (Nov 2022)
* [Apache Pinot 0.11 - Inserts from SQL](https://pinot.apache.org/blog/2022/11/17/Apache%20Pinot-Inserts-from-SQL/) - Mark Needham (Nov 2022)
* [Apache Pinot 0.11 - How do I see my indexes?](https://pinot.apache.org/blog/2022/11/08/Apache%20Pinot-How-do-I-see-my-indexes/) - Mark Needham (Nov 2022)
* [GapFill Function For Time-Series Datasets In Pinot](https://pinot.apache.org/blog/2022/08/02/GapFill-Function-For-Time-Series-Datasets-In-Pinot/) - Weixiang Sun, Lakshmanan Velusamy (Aug 2022)
* [Announcing Apache Pinot 0.10](https://pinot.apache.org/blog/2022/04/04/Announcing-Apache-Pinot-0-10/) (Apr 2022)

### 2021

* [Text analytics on LinkedIn Talent Insights using Apache Pinot](https://pinot.apache.org/blog/2021/06/16/LinkedIn-TextAnalytics/) - LinkedIn Engineering (Jun 2021)
* [Introduction to Geospatial Queries in Apache Pinot](https://pinot.apache.org/blog/2021/06/13/DevBlog-Geospatial/) - Hubert Dulay (Jun 2021)
* [Automating Merchant Live Monitoring with Real-Time Analytics - Charon](https://pinot.apache.org/blog/2021/04/29/Uber-Charon/) - Uber Data Team (Apr 2021)
* [Deploying Apache Pinot at a Large Retail Chain](https://pinot.apache.org/blog/2021/04/27/DevBlog-PinotInRetailChain/) (Apr 2021)
* [Solving for the cardinality of set intersection at scale with Pinot and Theta Sketches](https://pinot.apache.org/blog/2021/04/16/LinkedIn-Theta/) - LinkedIn Engineering (Apr 2021)
* [Introduction to Upserts in Apache Pinot](https://pinot.apache.org/blog/2021/04/08/DevBlog-UpsertsIntro/) - Hubert Dulay (Apr 2021)
* [Real-time Analytics with Presto and Apache Pinot](https://pinot.apache.org/blog/2021/02/02/DevBlog-PrestoPinot/) (Feb 2021)
* [Change Data Analysis with Debezium and Apache Pinot](https://pinot.apache.org/blog/2021/01/08/DevBlog-DebeziumCDC/) - Hubert Dulay (Jan 2021)

### 2020

* [From Lambda to Lambda-less Lessons learned](https://pinot.apache.org/blog/2020/12/01/LinkedIn-Lamda/) - LinkedIn Engineering (Dec 2020)
* [Operating Apache Pinot at Uber Scale](https://pinot.apache.org/blog/2020/10/20/Uber-Operating/) - Uber Data Team (Oct 2020)
* [Deep Analysis of Russian Twitter Trolls](https://pinot.apache.org/blog/2020/10/16/DevBlog-TwitterTrollAnalysis/) - Hubert Dulay (Oct 2020)
* [Building a Climate Dashboard with Apache Pinot and Superset](https://medium.com/apache-pinot-developer-blog/building-a-climate-dashboard-with-apache-pinot-and-superset-d3ee8cb7941d) - Apache Pinot Developer Blog (Sep 2020)
* [Leverage Plugins to Ingest Parquet Files from S3 in Pinot](https://pinot.apache.org/blog/2020/08/08/DevBlog-IngestPlugins/) (Aug 2020)
* [Monitoring Apache Pinot with JMX, Prometheus and Grafana](https://pinot.apache.org/blog/2020/08/08/DevBlog-PinotMonitoring/) (Aug 2020)
* [Achieving 99th percentile latency SLA using Apache Pinot](https://pinot.apache.org/blog/2020/08/08/DevBlog-SLAApps/) (Aug 2020)
* [Utilize UDFs to Supercharge Queries in Apache Pinot](https://pinot.apache.org/blog/2020/08/08/DevBlog-ScalarUDFs/) (Aug 2020)
* [Building a culture around metrics and anomaly detection](https://pinot.apache.org/blog/2020/07/28/DevBlog-AnomalyDetection/) - Hubert Dulay (Jul 2020)
* [Moving developers up the stack with Apache Pinot](https://pinot.apache.org/blog/2020/07/28/DevBlog-DevUpStack/) - Hubert Dulay (Jul 2020)
* [Bridging batch and stream processing for the Recruiter usage statistics dashboard](https://pinot.apache.org/blog/2020/07/14/LinkedIn-BatchRealtime/) - LinkedIn Engineering (Jul 2020)
* [Building LinkedIn Talent Insights to democratize data-driven decision making](https://pinot.apache.org/blog/2020/06/29/LinkedIn-TalentInsight/) - LinkedIn Engineering (Jun 2020)
* [Monitoring business performance data with ThirdEye smart alerts](https://pinot.apache.org/blog/2020/06/25/LinkedIn-SmartAlerts/) - LinkedIn Engineering (Jun 2020)
* [Exploring OLAP on Kubernetes with Apache Pinot](https://medium.com/apache-pinot-developer-blog/exploring-olap-on-kubernetes-with-apache-pinot-32f12233dc0b) - Apache Pinot Developer Blog (Jun 2020)
* [Introducing Apache Pinot 0.3.0](https://engineering.linkedin.com/blog/2020/apache-pinot-030-update) - LinkedIn Engineering (Apr 2020)
* [Using Apache Pinot and Kafka to Analyze GitHub Events](https://medium.com/apache-pinot-developer-blog/using-apache-pinot-and-kafka-to-analyze-github-events-93cdcb57d5f7) - Apache Pinot Developer Blog (Apr 2020)
* [Analyzing anomalies with ThirdEye](https://engineering.linkedin.com/blog/2020/analyzing-anomalies-with-thirdeye) - LinkedIn Engineering (Feb 2020)
* [Engineering SQL Support on Apache Pinot at Uber](https://eng.uber.com/engineering-sql-support-on-apache-pinot/) - Uber Engineering (Jan 2020)

### 2019

* [Auto-Tuning Pinot Real-Time Consumption](https://engineering.linkedin.com/blog/2019/auto-tuning-pinot) - LinkedIn Engineering (Jul 2019)
* [Star-Tree Index: Powering Fast Aggregations on Pinot](https://engineering.linkedin.com/blog/2019/06/star-tree-index--powering-fast-aggregations-on-pinot) - LinkedIn Engineering (Jun 2019)
* [Smart Alerts in ThirdEye, LinkedIn's Real-Time Monitoring Platform](https://engineering.linkedin.com/blog/2019/06/smart-alerts-in-thirdeye--linkedins-real-time-monitoring-platfor) - LinkedIn Engineering (Jun 2019)
* [Pinot Joins Apache Incubator](https://engineering.linkedin.com/blog/2019/03/pinot-joins-apache-incubator) - LinkedIn Engineering (Mar 2019)
* [Introducing ThirdEye: LinkedIn's Business-Wide Monitoring Platform](https://engineering.linkedin.com/blog/2019/01/introducing-thirdeye--linkedins-business-wide-monitoring-platfor) - LinkedIn Engineering (Jan 2019)

### 2017

* [Engineering Restaurant Manager, our UberEATS Analytics Dashboard](https://eng.uber.com/restaurant-manager/) - Uber Engineering (Sep 2017)

### 2015

* [Open Sourcing Pinot: Scaling the Wall of Real-Time Analytics](https://engineering.linkedin.com/pinot/open-sourcing-pinot-scaling-wall-real-time-analytics) - LinkedIn Engineering (Jun 2015)
* [A Brief History of Scaling LinkedIn](https://pinot.apache.org/blog/2015/05/16/LinkedIn-Scaling/) - LinkedIn Engineering (May 2015)

## Engineering Blogs from Adopters

### Uber Engineering

* [Rebuilding Uber's Apache Pinot Query Architecture](https://www.uber.com/blog/rebuilding-ubers-apache-pinot-query-architecture/) (Jan 2025)
* [Serving Millions of Apache Pinot Queries with Neutrino](https://www.uber.com/blog/serving-millions-of-apache-pinot-queries-with-neutrino/) (Dec 2024)
* [Building Zone Failure Resilience in Apache Pinot at Uber](https://www.uber.com/blog/building-zone-failure-resilience-in-apache-pinot-at-uber/) (Nov 2024)

### LinkedIn Engineering

* [Real-time analytics on network flow data with Apache Pinot](https://engineering.linkedin.com/blog/2022/real-time-analytics-on-network-flow-data-with-apache-pinot) (2022)
* [Text analytics on LinkedIn Talent Insights using Apache Pinot](https://engineering.linkedin.com/blog/2021/text-analytics-on-linkedin-talent-insights-using-apache-pinot) (2021)

### Grab Engineering

* [Powering Partner Gateway metrics with Apache Pinot](https://engineering.grab.com/pinot-partnergateway-tech-blog)

## Third-Party Blogs and Tutorials

### Medium / Apache Pinot Developer Blog

* [Optimizing Workflow Log Management with Apache Pinot: An Upsert Approach](https://medium.com/@shruti1810/optimizing-workflow-log-management-with-apache-pinot-an-upsert-approach-016cc9293bea) (Sep 2024)
* [Apache Pinot 0.11 Released](https://medium.com/apache-pinot-developer-blog/apache-pinot-0-11-released-d564684df5d4) (Sep 2022)
* [Real-time Analytics with Presto and Apache Pinot — Part I](https://medium.com/apache-pinot-developer-blog/real-time-analytics-with-presto-and-apache-pinot-part-i-cc672caea307) (Sep 2022)
* [CDC-based Upserts with Debezium, Apache Kafka, and Apache Pinot](https://medium.com/event-driven-utopia/cdc-based-upserts-with-debezium-apache-kafka-and-apache-pinot-427cced24eb1) (Jul 2022)
* [Moving developers up the stack with Apache Pinot](https://medium.com/apache-pinot-developer-blog/moving-developers-up-the-stack-with-apache-pinot-29d36717a3f4) (Dec 2021)
* [Announcing Apache Pinot 0.7.1](https://medium.com/apache-pinot-developer-blog/announcing-apache-pinot-0-7-1-31b46ad6b0f6) (Apr 2021)

### Industry Analyst Coverage

* [Apache Pinot 1.0 Provides a Realtime Distributed OLAP Datastore](https://www.infoq.com/news/2023/12/apache-pinot/) - InfoQ (Dec 2023)
* [Building Latency Sensitive User Facing Analytics via Apache Pinot](https://www.infoq.com/articles/analytics-apache-pinot/) - InfoQ

### Cloud Provider Blogs

* [Build a real-time analytics solution with Apache Pinot on AWS](https://aws.amazon.com/blogs/big-data/build-a-real-time-analytics-solution-with-apache-pinot-on-aws/) - AWS Big Data Blog (Aug 2024)

### Confluent

* [Real-Time Analytics with Apache Kafka and Pinot](https://www.confluent.io/blog/real-time-analytics-with-kafka-and-pinot/) - Confluent Blog (2020)

### DZone

* [How to Stream Sensor Data to Apache Pinot for Real Time Analysis](https://dzone.com/articles/how-to-stream-sensor-data-to-apache-pinot-for-real)
* [Setting up Apache Pinot on Kubernetes in Under 15 Minutes](https://dzone.com/articles/setting-up-apache-pinot-on-kubernetes-in-under-15)

### Other

* [Real-Time App Performance Monitoring with Apache Pinot](https://www.analyticsvidhya.com/blog/2024/09/real-time-app-performance-monitoring-with-apache-pinot/) - Analytics Vidhya (Sep 2024)
* [Exploring Apache Pinot](https://aurigait.com/blog/exploring-apache-pinot/) - Auriga IT (2024)

## StarTree Resources

For StarTree-specific blog posts on Apache Pinot features, best practices, and use cases, visit the [StarTree Resources page](https://startree.ai/resources/).

Notable posts include:

* [Apache Kafka and Apache Pinot – Built together to work together](https://startree.ai/resources/apache-kafka-and-apache-pinot/)
* [Consistent, Scalable Compaction for Real-Time Upserts in Apache Pinot](https://startree.ai/resources/upserts-compaction-in-apache-pinot-startree/) (Mar 2025)
* [Inside the flight path of real-time ingestion in Apache Pinot (Part 2)](https://startree.ai/resources/inside-the-flight-path-of-real-time-ingestion-in-apache-pinot-part-2/) (Mar 2025)
* [Apache Pinot – a scalable alternative to ElasticSearch for log analytics](https://startree.ai/resources/scalable-alternative-to-elasticsearch-for-log-analytics/) (2025)
* [Flattening JSON Objects in Pinot for Performance and Efficiency](https://startree.ai/resources/flattening-json-objects-in-pinot-for-performance-and-efficiency/) (2025)
* [Apache Pinot Year in Review 2024](https://startree.ai/resources/apache-pinot-year-in-review-2024/) (Dec 2024)
* [Clickstream and Funnel Analysis with Apache Pinot and StarTree](https://startree.ai/resources/clickstream-funnel-analysis-with-apache-pinot-startree/) (2024)
* [Introducing Tiered Storage in Apache Pinot](https://startree.ai/blog/introducing-tiered-storage) (2023)
* [Grape to Glass: Apache Pinot 1.0 Uncorked](https://startree.ai/blog/from-grape-to-glass-apache-pinot-graduates-like-a-fine-wine) (2023)
* [What Makes Apache Pinot Fast - Part 1](https://startree.ai/blog/what-makes-apache-pinot-fast-chapter-1)
* [Capacity Planning in Apache Pinot - Part 1](https://www.startree.ai/blog/capacity-planning-in-apache-pinot-part-1)
* [Best Practice Table Design In Apache Pinot](https://startree.ai/blog/best-practices-for-designing-tables-in-apache-pinot)
* [Apache Pinot 2021 Recap and 2022 Roadmap](https://startree.ai/resources/apache-pinot-2021-recap-and-2022-roadmap/)