Imply Videos

Dec 9, 2022

Druid SQL for Queries – from an Overview to Tips and Tricks

SQL is a powerful and elegant query language for databases. Druid is increasingly supporting and moving forward with SQL, which is arguably easier to learn and write than the original native (JSON) query language. This talk will discuss the Druid implementation of SQL, focusing on querying data. How does it work? What parts of SQL are and aren’t supported? What are some gotchas, and tips and tricks, for people new to it? We’ll focus on querying data. We’ll also briefly discuss the new multi-stage query engine and SQL syntax for ingesting or transforming data, but the main focus will be on writing good, efficient queries.