Archive of category 'sql'

• 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

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

  Analyzing GitHub Stars with Imply Polaris

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

  Druid Sneak Peek: Schema Inference and Arrays

• 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

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

  Druid Data Cookbook: Cumulative Sums in Druid SQL

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

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