Cubing and Metrics in SQL - Extending Apache Calcite for Advanced Analytics

Explore Apache Calcite's SQL extensions for metrics, measures, filter context, and analytic expressions in this 36-minute talk by Julian Hyde, the original developer of Apache Calcite. Learn how to define data models called Analytic Views containing metrics, use them in queries, and create new metrics within queries. Discover the SQL syntax extensions for metrics and their application in cross-dimensional calculations such as period-over-period, percent-of-total, non-additive, and semi-additive measures. Gain insights into overcoming fundamental limitations in SQL semantics and approaches for optimizing queries that use metrics. Presented at Data Council, this talk offers valuable knowledge for data professionals interested in advanced SQL techniques and data management systems.