5 Reasons Why AI Is the Future of SQL – Jared Zhao, AskEdith

5 Reasons Why AI Is the Future of SQL – Jared Zhao, AskEdith

SQL remains ubiquitous for data retrieval and analytics, yet can be tedious to write, and is downright unusable for business users. The 2-5 business day turnaround time for data projects is both disruptive and frustrating for business users. Data teams are becoming increasingly overwhelmed, and organizations are pushing to empower their “citizen data analysts.” With the advent of AI English-to-SQL platforms like AskEdith, now anyone can work with and query Presto using plain English questions. AskEdith integrates natively with web interfaces like Ahana for a seamless analytics experience.

Common Sub Expression Optimization at Facebook

Common Sub Expression Optimization at Facebook

In complex analytics queries, we often see repeated expressions, for example parsing the same JSON column but extracting different fields, elaborate CASE statement with common predicates and different ones. Previously, Presto will compute the same expression many times as they appear in query. With common sub expression optimization, we would only evaluate the same expression once within the same project operator or filter operator. In our workload, we’ve seen 3x improvements on certain queries with expensive common sub expressions like JSON_PARSE. Microbenchmark also shows a consistent ~10% performance improvement for simple common sub-expressions like x + y. In this talk, we will talk about how this is implemented.