#JOIN2019: The Effect of Relational Algebra on Looker's Query Engine
#JOIN2019 Session No. 12: "Smarter Together: Bringing Relational Algebra, Powered by Apache Calcite, into Looker's Query Engine" What if Looker saw the queries you just executed and could predict your next query? Could it make those queries faster, by smarter caching, or aggregate navigation? Could it read your past SQL queries and help you write your LookML model? Those are some of the reasons to add relational algebra into Looker’s query engine, and why Looker hired Julian Hyde, author of #ApacheCalcite, to lead the effort. In this session about the internals of Looker’s query engine, Julian Hyde describes how the engine works, how Looker queries are described in Calcite’s relational algebra, and some features that it makes possible.