> Modeling

Modeling

Learn the best practices for data modeling in Druid from partioning to schema design patterns and nested data.

Senthil Vallinayagam

The Promise (and Limitations) of Range Partitions

Learn how to improve read times with range partitions.

#modeling #msq #rangepartitions #sql

Kumar Abhishek

An Introduction to Window Functions

Learn all about window functions

#modeling #sqlsyntax #windowfunctions

Kashif Faraz

Multi-dimensional range partioning in Druid

Druid always partitions data by the timestamp dimension to benefit time-based analytical queries. A secondary partitioning is available to further break down the time chunks into manageable partition sizes.

#modeling

Gian Merlino

Joins in Apache Druid

This blog explores Druid’s multiple options for joins, including ingestion-time and query-time joins, catering to different use cases and data scenarios.

#modeling

Jad Naous

Upserts and Data Deduplication with Druid

This article explains several options to accomplish upserts and data deduplication in Apache Druid.

#ingestion #modeling

Soumyava Das

Exploring Unnest in Druid

This article shows how Druid supports multi-value strings through multi-value dimensions (MVDs), which automatically flattens during a group-by.

#ingestion #modeling

Sergio Ferragut

Learn how to achieve sub-second responses with Apache Druid

A review of Druid’s query processing engine with an eye on performance. Provides many data modeling and query tips that improve response times.

#modeling #performance

Matt Morrissey

The Significance of Schema Auto-Discovery in Apache Druid

This article provides a technical overview of the schema auto-discovery feature in Apache Druid through a practical IoT telemetry use case.

#modeling #schema

Senthil Vallinayagam

How to Execute Window Functions on Sketches

Learn how to use SQL window functions in Apache Druid.

#modeling #sketches #windowfunctions

Darin Briskman

Working with changing data

This lesson covers key considerations when working with data sources that mutate over time, including creating tables from streaming data and using schema auto-discovery.

#modeling #schema #streaming

Darin Briskman

Working with Nested JSON in Druid

This lesson covers key considerations for how to use nested data in Apache Druid.

#modeling #schema

Marc Farnsworth

How to Use Window Functions and Theta Sketches for User Behavior Analytics

Learn how Theta Sketches and window functions can power user behavior analytics

#modeling #gamesanalytics #thetasketches #windowfunctions

Sergio Ferragut

Pruning in Druid

Fourth and last video in the Partitioning Series that describes and demos how different partitioning strategies provide segment pruning at query time.

#ingestion #modeling

Sergio Ferragut