# 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/)


---

# Agent Instructions: Querying This Documentation

If you need additional information that is not directly available in this page, you can query the documentation dynamically by asking a question.

Perform an HTTP GET request on the current page URL with the `ask` query parameter:

```
GET https://docs.pinot.apache.org/resources/blogs.md?ask=<question>
```

The question should be specific, self-contained, and written in natural language.
The response will contain a direct answer to the question and relevant excerpts and sources from the documentation.

Use this mechanism when the answer is not explicitly present in the current page, you need clarification or additional context, or you want to retrieve related documentation sections.