v.24.9New Feature
Add arrayZipUnaligned function for Spark compatibility
Add new functionarrayZipUnalignedfor spark compatibility (which is namedarrays_zipin Spark), which allowed unaligned arrays based on originalarrayZip. #69030 (李扬).
Why it matters
The feature solves the problem of requiring arrays to be aligned in length when usingarrayZip. By allowing unaligned arrays, it matches Spark's behavior and improves interoperability and flexibility when processing arrays of different lengths.How to use it
Use the new functionarrayZipUnaligned in your queries in place of arrayZip. It works similarly but allows input arrays of different lengths without truncation to the shortest array.