September 2022 Update

Documentation

• Document flat-no-nulls fast path in expression evaluation.

• Document encoding-preserving vector serialization format.

• Document ANTI join semantics.

• Document RIGHT SEMI join.

• Document Velox types.

Core Library

• Add spilling support for hash join build.

• Add support for flattening concat-like function calls in expression evaluation.

Presto Functions

• Add rank(), dense_rank() and percent_rank() window functions.

• Add zip_with() function.

• Add support for casting JSON string to a struct.

• Add support for DECIMAL inputs to multiply(), divide(), between(), eq(), gt(), lt(), gte() and lte() functions.

• Add support for TIMESTAMP WITH TIME ZONE inputs to date_format() function.

• Add support for calculating multiple percentiles to approx_percentile() function. #2418

• Optimize LIKE operator for prefix, suffix and other simple patterns. #1763

• Optimize concat() function. #2584, #2551, #2498

• Fix approx_percentile() function when used in intermediate aggregation.

• Fix min() and max() aggregate functions for DATE inputs.

Substrait Extension

• Add support for IF and SWITCH expressions.

Performance and Correctness

• Add support for AND/OR expressions and functions with variadic arguments to Fuzzer.

• Add logic to save input vector and expression SQL to files when expression evaluation fails. This functionality is disabled by default. Use –velox_save_input_on_expression_any_failure_path=/tmp gflag to enable for all exception or –velox_save_input_on_expression_system_failure_path=/tmp to enable for system exceptions only. #2662

• Fix multiple issues found by the ThreadSanitizer.

Credits

Aditi Pandit, Austin Dickey, Behnam Robatmili, Bikramjeet Vig, Bo Yang, Deepak Majeti, Huameng Jiang, Jake Jung, Jialiang Tan, Jimmy Lu, Karteek Murthy Samba Murthy, Kevin Wilfong, Krishna Pai, Laith Sakka, Masha Basmanova, Michael Bolin, Miłosz Linkiewicz, Orri Erling, Pavel Solodovnikov, Pedro Eugenio Rocha Pedreira, Pramod, Randeep Singh, Raúl Cumplido, Serge Druzkin, Sergey Pershin, Wei He, Xiaoxuan Meng, Xuedong Luan, Zeyi (Rice) Fan, Zhang, Chaojun, Zhenyuan Zhao, erdembilegt.j, leoluan2009, lingbin, tanjialiang, xiaoxmeng, yingsu00, zhejiangxiaomai, zhaozhenhui