Google, IBM & Meta Certificates — All 10,000+ Courses at 40% Off
One annual plan covers every course and certificate on Coursera. 40% off for a limited time.
Get Full Access
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.
