Author: Wenlei Xie

Software Engineer at PyTorch

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…
Read More Querying Nested Data with Lambda Functions
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…
Read More Presto Unlimited: MPP SQL Engine at Scale