In this short post I want to take a closer look at Imply Pivot and how to address a common scenario for analytics: Let’s assume we want to filter on a dimension value, but we want to exclude rather than include a set of dimension values.

Let’s do some customer segmentation in our little restaurant!

In which we continue the quest about multi-value handling and try to answer the question: Why are we even doing this?

This is part 2 of a miniseries about multi-value dimensions in Apache Druid. More posts can be found here:

• part 1
• part 3
• part 4
• part 5