Wenlei Xie, Author at PrestoDB

Querying Nested Data with Lambda Functions

By Wenlei Xie March 2, 2020September 21, 2023

Denormalized data with nested values (e.g. array/map) have become omnipresent in this Big Data era, as a lot of data naturally conforms to a nested representation [1, 2]. As a result it is important to provide an efficient and convenient way to query nested data. SQL traditionally does not include support for this. The pioneering…

Presto Unlimited: MPP SQL Engine at Scale

By Wenlei Xie, Andrii Rosa, Shixuan Fan, Tim Meehan & Rebecca Schlussel August 5, 2019September 21, 2023

Presto is an open source distributed SQL query engine for running analytic queries against data sources of all sizes ranging from gigabytes to petabytes. Presto was originally designed for interactive use cases, however, after seeing the merit in having a single interface for both batch and interactive, it is now also used heavily for processing…