October 2022 Update

Core Library

• Add regular (not null aware) Anti Join. #2906

• Add spilling support for Hash Join.

• Add query configuration properties to configure spilling: spill_enabled, aggregation_spill_enabled, join_spill_enabled, order_by_spill_enabled, aggregation_spill_memory_threshold, order_by_spill_memory_threshold.

• Fix signatures of simple functions using custom types. #2965

Presto Functions

• Add truncate() function.

• Add map_zip_with() function.

• Add nth_value() and cume_dist() window functions.

• Optimize cardinality() function.

• Fix from_unixtime() for NaN input. #2936

• Fix array_sum() for constant input. #2932

• Fix array_intersect() and array_except() for dictionary encoded or null input. #2959

• Fix arrays_overlap(), array_intersect(), and array_except() when one argument is a constant array with dictionary-encoded elements. #2954

• Fix sum(real) aggregate function.

• Fix CAST to JSON when invoked inside of a TRY.

• Fix lambda functions when invoked inside of a TRY.

Hive Connector

• Add support for DECIMAL types to Parquet reader.

• Add support for S3 FileSystem compatible schemes s3a and oss. #2410

Performance and Correctness

• Add mechanism to reproduce Fuzzer failures reliably: run ExpressionFuzzer with –repro_persist_path flag to save repro files, then run ExpressionRunner to reproduce.

• Add support for functions that take or return complex type values to Fuzzer. Use –velox_fuzzer_enable_complex_types flag to enable.

• Add support for LazyVector to VectorSaver and VectorFuzzer.

Debugging Experience

• Add printIndices(indices) and printNulls(nulls) functions. #2723 and #2721

Credits

Adalto Correia, Aditi Pandit, Amit Dutta, Austin Dickey, Bikramjeet Vig, Chad Austin, Deepak Majeti, Ge Gao, Giuseppe Ottaviano, Gosh Arzumanyan, Huameng Jiang, Ivan Morett, Jacob Wujciak-Jens, Jake Jung, Jialiang Tan, Jimmy Lu, Kevin Wilfong, Krishna Pai, Laith Sakka, Masha Basmanova, Michael Liu, Michael Shang, Mike Decker, Milosz Linkiewicz, Open Source Bot, Orri Erling, Patrick Somaru, Pavel Solodovnikov, Pedro Eugenio Rocha Pedreira, Pedro Pedreira, Pramod, Qitian Zeng, Randeep Singh, Raúl Cumplido, Sergey Pershin, Uhyon Chung, Vinti Pandey, Wei He, Weile Wei, Zeyi (Rice) Fan, Zhenyuan Zhao, mwish, shengxuan.liu, tanjialiang, xiaoxmeng, yingsu00, zhejiangxiaomai