September 2021 Update

Documentation

• Add new articles: Vectors and Joins.

• Add Presto functions coverage maps: all and most used.

Core Library

• Add support for converting flat Velox vectors of primitive types to Arrow arrays.

• Add support for round-robin and Hive-compatible partitioning.

• Add support for LEFT OUTER and CROSS joins.

• Add EnforceSingleRow operator to support uncorrelated subqueries.

• Add function registry API.

• Enable dynamic filter pushdown for semi joins.

• Enable all-ASCII fast path for all eligible string functions.

• Fix the long standing problem of constant vectors not knowing their size and delete kMaxElements constant.

• Add ExpressionFuzzer tests to CircleCI and increase coverage.

Presto Functions

• Add array_distinct(), array_except(), reverse(array) functions.

• Add millisecond() function.

• Add trim(), ltrim(), rtrim() functions.

• Add sin(), asin(), cos(), acos(), tan(), atan(), atan2(), cosh(), tanh() functions.

• Add to_utf8(), url_encode(), url_decode(), to_base64(), from_base64(), to_hex(), from_hex() functions..

• Add BETWEEN operator for strings.

• Add stddev_pop(), stddev_samp(), var_pop(), var_samp() aggregate Presto functions.

• Add timestamp with time zone Presto type.

Credits

Adam Simpkins, Aditi Pandit, Amit Dutta, Andy Lee, Aniket Mokashi, Anuradha Weeraman, Chao Chen, Christy Lee-Eusman (PL&R), Darren Fu, Deepak Majeti, Huameng Jiang, Jake Jung, Jialiang Tan, Krishna Pai, MJ Deng, Masha Basmanova, Michael Shang, Orri Erling, Pedro Eugenio Rocha Pedreira, Ravindra Sunkad, Rob Kinyon, Sagar Mittal, Sarah Li, Sergey Pershin, Sourav Kumar, Stefan Roesch, Wenlei Xie, Yuan Chao Chou, Yue Yin, Zeyi (Rice) Fan, Zhengchao Liu, Zhenyuan Zhao, amaliujia, ienkovich, miaoever.