• OLAP - Data Storage

    Advanced Apache Pinot: Optimizing Performance and Querying with Enhanced Project Setup

    November 30, 2023 - By 

    Originally published on November 30, 2023 In this third part of our Apache Pinot series, we’ll focus on performance optimization and query enhancements within our sample project. Now that we have a foundational setup, we’ll add new features for monitoring real-time data effectively, introducing optimizations that make queries faster and more efficient. Enhancing the Sample Project: Real-Time Analytics with Aggregations and Filtering In this version of the sample project, we’ll continue with our social media analytics setup, adding fields and optimizing tables to support complex aggregations and filtering on geo-location for more detailed insights. New Project Structure Enhancements: data: Additional…

  • OLAP - Data Storage

    Advanced Apache Pinot: Sample Project and Industry Use Cases

    November 16, 2023 - By 

    As we dive deeper into Apache Pinot, this post will guide you through setting up a sample project. This hands-on project aims to demonstrate Pinot’s real-time data ingestion and query capabilities and provide insights into its application in industry scenarios. Whether you’re looking to power recommendation engines, enhance user analytics, or build custom BI dashboards, this blog will help you establish a foundation with Apache Pinot. Introduction to the Sample Project The sample project will simulate a real-time analytics dashboard for a social media application. We’ll analyze user interactions in near-real-time, covering a setup from data ingestion through to visualization.…

  • Data Storage - OLAP

    Mastering Apache Druid: Performance Tuning, Query Optimization, and Advanced Ingestion Techniques

    November 16, 2023 - By 

    Introduction In this third part of our Apache Druid series, we’ll explore how to get the most out of Druid’s powerful real-time analytics capabilities. After setting up your Druid cluster and understanding industry use cases, it’s time to learn the nuances of performance tuning, query optimization, and advanced ingestion techniques to maximize efficiency. This post will cover optimization strategies, advanced query configurations, and data ingestion tips to enhance performance and responsiveness. We’ll also revisit our E-commerce Sales Analytics Dashboard sample project from the previous post, applying these techniques to build a more robust and responsive real-time analytics solution. 1. Performance…