Archive of category 'blog'

• Mar 9, 2025 • blog, clickhouse, sql, tutorial

  ClickHouse Data Cookbook: Visitor Segmentation with Theta Sketches

• Jan 12, 2025 • blog, clickhouse, sql, tutorial

  ClickHouse Data Cookbook: Aggregating Latest Values

• Jan 5, 2025 • blog, clickhouse, sql, tutorial

  ClickHouse Data Cookbook: Linear Algebra in SQL

• Jan 1, 2025 • blog, clickhouse, sql, tutorial

  New Year's Greetings from the Data Cookbook Elf!

• Oct 20, 2024 • blog, apache, druid, imply, sql, ingestion, tutorial

  Druid 31 Preview: Changing the Segment Sort Order

• Oct 6, 2024 • blog, imply, sql, datamodel, warehouse, tutorial

  Table Based Lookups in Imply Polaris

• Sep 27, 2024 • blog, apache, druid, imply, sql, tutorial

  Druid Data Cookbook: Deconstructing Nested JSON Objects

• Sep 22, 2024 • blog, apache, druid, imply, sql, tutorial

  Druid Data Cookbook: Flattening Arrays of Complex Objects

• Jun 24, 2024 • blog, apache, druid, imply, sql, tutorial

  Druid Data Cookbook: Parameterizing the IN clause

• Apr 28, 2024 • blog, apache, druid, imply, sql, tutorial

  Druid Data Cookbook: About SQL NULL

• Mar 1, 2024 • blog, apache, druid, imply, sql, tutorial

  New in Druid 29: Exporting Query Results

• Jan 15, 2024 • blog, apache, druid, imply, sql, tutorial

  Druid 29 Preview: Transposing Data with PIVOT and UNPIVOT

• Dec 17, 2023 • blog, apache, druid, imply, sql, tutorial

  Druid 29 Preview: Handling Nested Arrays

• Nov 25, 2023 • blog, druid, sql, imply, adtech, tutorial, update, crud

  Druid Data Cookbook: Upserts in Druid SQL

• Nov 3, 2023 • blog, apache, druid, sql

  Druid SQL: BETWEEN considered harmful

• Oct 29, 2023 • blog, apache, druid, imply, streaming, kafka, tutorial

  Druid 28 Sneak Peek: Ingesting Multiple Kafka Topics into One Datasource

• Sep 24, 2023 • blog, imply, polaris, druid, data_lifecycle

  New in Imply Polaris: Data Retention Policy

• Sep 7, 2023 • blog, druid, imply, query, storage

  New in Apache Druid 27: Querying Deep Storage

• Aug 29, 2023 • druid, minio, tutorial, blog

  Using Druid with MinIO

• Jul 30, 2023 • blog, apache, druid, imply, visualization, tutorial

  Druid Sneak Peek: Graphical Data Exploration

• Jul 25, 2023 • blog, apache, druid, imply, realtime

  Merging Realtime Segments in Apache Druid

• Jul 12, 2023 • blog, druid, imply, polaris, sql, datamodeling, tutorial

  Analyzing GitHub Stars with Imply Polaris

• Jun 28, 2023 • blog, druid

  Indexes in Apache Druid

• Jun 27, 2023 • blog, imply, druid, kafka, json, tutorial

  New in Druid 26: Data Provenance Tracking with Kafka Headers, Automatically

• May 31, 2023 • blog, druid, imply, pivot, tutorial

  Overlaying Multiple Metrics in Imply Pivot

• May 1, 2023 • blog, apache, druid, imply, iot, sql, tutorial

  Druid Sneak Peek: Schema Inference and Arrays

• Apr 23, 2023 • blog, apache, druid, imply

  Multi-Value Dimensions in Apache Druid (Part 5)

• Apr 8, 2023 • blog, apache, druid, imply, iot, sql, tutorial

  Druid Sneak Peek: Timeseries Interpolation

• Mar 26, 2023 • blog, apache, druid, imply, sql, tutorial

  Druid 26 Sneak Peek: Window Functions

• Mar 7, 2023 • blog, druid, imply, adtech, tutorial, update, crud

  Selective Bulk Upserts in Apache Druid

• Feb 14, 2023 • blog, druid, imply, polaris, saas, eventstreaming, redpanda, kafka

  Streaming Events from Redpanda Cloud into Imply Polaris

• Feb 1, 2023 • blog, druid, imply, pivot, confluent, kafka, tutorial

  Street Level Maps in Imply Pivot with Flight Data and Confluent Cloud

• Jan 29, 2023 • blog, apache, druid, imply, tutorial

  Druid Data Cookbook: Array as JSON

• Jan 22, 2023 • blog, druid, tutorial

  Apache Druid: Data Lifecycle Management

• Jan 12, 2023 • blog, apache, druid, imply, kafka, confluent

  Building an Event Analytics Pipeline with Confluent Cloud and Imply Polaris

• Jan 8, 2023 • blog, apache, druid, imply, tutorial

  Druid Data Cookbook: Modeling Flag Lists

• Dec 26, 2022 • blog, imply, druid, tutorial

  Ingesting Data Sketches into Apache Druid

• Nov 23, 2022 • blog, imply, druid, kafka, json, tutorial

  Processing Nested JSON Data and Kafka Metadata in Apache Druid

• Nov 5, 2022 • blog, apache, druid, imply, sql, tutorial

  Druid Data Cookbook: Cumulative Sums in Druid SQL

• Oct 12, 2022 • blog, imply, druid, tutorial

  Druid Data Cookbook: Lookups at Ingestion Time

• Oct 2, 2022 • blog, imply, druid, alert, pivot, tutorial

  Advanced Alert Scheduling in Imply Pivot

• Sep 25, 2022 • blog, druid, imply, pivot, analytics, tutorial, gaming

  Tutorial: Cohort Analysis with Imply

• Aug 30, 2022 • blog, druid, imply, tutorial, kafka, streamprocessing, sql, flink, decodable

  Processing Flight Radar (ADS-B) Data with Imply, Decodable, and Confluent Cloud

• Aug 10, 2022 • blog, druid, imply, timeseries, analytics, tutorial

  Timeseries Data in Apache Druid: Getting the Latest Value with Rolled Up Data

• Jul 31, 2022 • blog, druid, imply, analytics, tutorial

  Using Imply Pivot with Druid to Deduplicate Timeseries Data

• Jul 16, 2022 • blog, druid, imply, ingestion, tutorial, kafka, tls, aiven

  Connecting Apache Druid to Kafka with TLS authentication

• Jun 26, 2022 • blog, imply, druid, kafka, eventstreaming, tutorial

  New in Druid 0.23: Ingesting Kafka Keys and Timestamps

• Jun 5, 2022 • blog, druid, imply, statistics, datasketches, tutorial

  Druid Data Cookbook: Counting Unique Visitors for Overlapping Segments

• May 26, 2022 • blog, imply, druid, confluent, kafka, eventstreaming, tutorial

  Ingesting Protobuf Messages into Apache Druid

• Apr 25, 2022 • blog, apache, druid, imply, pulsar, streamnative, eventstreaming, tutorial

  Integrating Apache Druid with Apache Pulsar

• Apr 2, 2022 • blog, druid, imply, polaris, saas, apache, nifi, eventstreaming, confluent, kafka

  Streaming Events from Confluent Cloud into Imply Polaris using Nifi

• Mar 20, 2022 • blog, druid, imply, statistics, datasketches, tutorial

  Druid Data Cookbook: Quantiles in Druid with Data Sketches

• Feb 21, 2022 • blog, imply, druid, geospatial, pivot, tutorial

  Visualizing Geospatial Data in Imply Pivot

• Feb 9, 2022 • blog, druid, imply, ingestion, tutorial

  Druid Data Cookbook: Ingestion Transforms

• Jan 25, 2022 • blog, apache, druid, imply, tutorial

  Partitioning in Druid - Part 3: Multi Dimension (Range) Partitioning

• Jan 21, 2022 • blog, apache, druid, imply

  Geospatial Data in Apache Druid - Generating Geohashes

• Jan 14, 2022 • blog, apache, druid, imply, tutorial

  Partitioning in Druid - Part 2: Single Dimension Partitioning

• Jan 6, 2022 • blog, apache, druid, imply, tutorial

  Partitioning in Druid - Part 1: Dynamic and Hash Partitioning

• Dec 31, 2021 • blog, druid, imply, adtech, tutorial, cpm, ecpm, impressions

  Apache Druid in AdTech: Computing eCPM values for rolled-up data

• Dec 21, 2021 • blog, apache, druid, imply, jq, tutorial

  Druid Data Cookbook - Multi-Value Dimensions Inside Lookups

• Dec 18, 2021 • blog, apache, druid, imply, nifi, tutorial

  Druid Lab - Processing Movie Tag Data

• Dec 11, 2021 • blog, druid, imply, ingestion, tutorial, snowflake, bigquery

  Semi-Structured Data in Apache Druid: Loading HN comments

• Dec 2, 2021 • blog, apache, druid, imply

  Druid Lab - Generating a Tag Cloud Using Rule Based Text Processing

• Nov 27, 2021 • blog, druid, imply, ingestion, tutorial

  Apache Druid: How Do I Get My Old Ingestion Logs Back?

• Nov 19, 2021 • blog, imply, druid, industry

  Apache Druid in the Publishing Industry

• Nov 15, 2021 • blog, image-compression

  Getting My Graphics Smaller - Experimenting with AVIF

• Nov 7, 2021 • blog, apache, druid, imply, spatial

  Fun with Spatial Dimensions in Apache Druid

• Oct 19, 2021 • blog, imply, druid, confluent, kafka, eventstreaming, tutorial

  Reading Avro Streams from Confluent Cloud into Apache Druid

• Oct 14, 2021 • blog, imply, druid

  Druid Data Modeling Special: Lookups and Multi-Value Dimensions

• Oct 10, 2021 • blog, apache, druid, imply, tutorial, pivot, regex

  Advanced Regex Exclude Filters in Imply Pivot

• Oct 3, 2021 • blog, apache, druid, imply

  Multi-Value Dimensions in Apache Druid (Part 4)

• Sep 25, 2021 • blog, apache, druid, imply

  Multi-Value Dimensions in Apache Druid (Part 3)

• Sep 5, 2021 • blog, apache, druid, imply

  Geospatial Data in Apache Druid - Ingestion

• Aug 29, 2021 • blog, apache, druid, imply

  Multi-Value Dimensions in Apache Druid (Part 2)

• Aug 22, 2021 • blog, apache, druid, imply, tutorial, pivot, operations

  Creating PagerDuty Alerts with Imply Pivot

• Aug 13, 2021 • blog, apache, druid, imply, tutorial, data-governance

  Experiments with Schema Evolution in Apache Druid

• Aug 7, 2021 • blog, apache, druid, imply

  Multi-Value Dimensions in Apache Druid (Part 1)

• Jul 31, 2021 • blog, imply, druid, business-intelligence

  Sending automatic email reports from Imply Pivot

• Jan 21, 2021 • blog, imply, druid

  Summary of Druid native query options

• May 13, 2020 • blog, perl, testing, financial, realtime, graph

  Generating IBAN numbers for simulated financial transactions

• Apr 25, 2020 • blog, perl, iot, dataflow, nifi

  A simple way to generate IoT test data

• Apr 21, 2020 • mail, linux, blog

  Rebuilding my mail server using OpenSMTPD on Debian

• Apr 20, 2020 • all, blog

  Welcome