Add release notes for 0.277

[pranjalssh]

Missing Release Notes

Amit Dutta

• [x] https://github.com/prestodb/presto/pull/18255 [native] Initailize systemconfig and nodeconfig as the first step of server run. (Merged by: Amit Dutta)
• [x] https://github.com/prestodb/presto/pull/18245 [native] Using fmt format for config directory path. (Merged by: Amit Dutta)

Feilong Liu

• [x] https://github.com/prestodb/presto/pull/18316 Add array find UDF (Merged by: Rebecca Schlussel)

Ge Gao

• [x] https://github.com/prestodb/presto/pull/18239 Add more gitignore for presto-native-execution (Merged by: Ge Gao)

Pranjal Shankhdhar

• [x] https://github.com/prestodb/presto/pull/18202 Union join nodes canonicalization (Merged by: Rebecca Schlussel)

Extracted Release Notes

• #17977 (Author: Svetoslav Zhelev): Implement handling of pinot binary columns
  • Implement handling of Pinot binary columns.
  • Added Pinot UDF for transforming Pinot binary column to Double. UDF: 'pinot_binary_decimal_to_double'.
  • N/a.
• #18099 (Author: Feilong Liu): Throw exception when number of nodes in logical plan exceeds threshold during query planning
  • Add support to throw exception when number of leaf nodes in plan exceeds a predefined limit during query planning. This can be enabled with the leaf_node_limit_enabled session property. The limit is set with the max_leaf_nodes_in_plan session property.
• #18150 (Author: Feilong Liu): Add timeout for query planning
  • Fix enforcement of query analyzer timeout during planning.
• #18247 (Author: dnskr): Upgrade Delta Standalone to 0.5.0
  • Upgrade Delta Standalone to 0.5.0.
• #18267 (Author: Feilong Liu): Fix CSE compilation error for duplicate expressions
  • Fix compilation error for common sub expression optimization when there are duplicate expressions in projection node.

All Commits

• b1601b3c298ccb899332e56347009b5780382318 Make aggregations order in Planner deterministic (Pranjal Shankhdhar)
• aae866e882c81fa82f858b086b87a007c2c07413 Add Injector parameter (Lin Liu)
• 733b23c0f76d56108c6943368e9bb8029193f320 Add array find UDF (Feilong Liu)
• a4817b16d6a48953fc1e166847a088a25a2142bb Add config to fallback to simple node selection when using TTL based scheduling (Neerad Somanchi)
• 4210c3d1ad03d3e631cdee0f64aecb2cd538eec6 Fix a typo in ParquetErrorCode enum (Xinli Shang)
• 0a11d83d1423ccb9e4fe89cbf3024204b64848bf Refactor to improve readability of QueryRunners (Ajay George)
• 8e2fbdad1399e2c319bfe00ded7b9495ff7a15a2 Load resource from jars using classloader (Michael Shang)
• f36cdec3e00fca748c85b970586ecb9d9e06f848 Fix Presto to Velox LongDecimal conversion (Deepak Majeti)
• 638105cc731a74cb5cec6f3cb03786e6fcccf55d Include presto-clickhouse in presto-tar plugin (Reetika Agrawal)
• bfa031e824e3f69ee136601325ddef425d672a5d Fix Ranger tests to be thread safe (Arunachalam Thirupathi)
• ed147d61bb926bf3d5967797f944325da4aa31b6 Fix CSE compilation error for duplicate expressions (Feilong Liu)
• 69bd48f7e571526d528a93f050e45abbe7c9a423 Throw exception when number of nodes in logical plan exceeds threshold (Feilong Liu)
• e1ef7dbbcaff3ed91942d399446c7e433b9e9228 Add stats read/written to QueryCompletedEvent (Pranjal Shankhdhar)
• 588bd55f93101b3202b97b8d692b17085d7d1a4b Add an empty function to start potential associated processes (Lin Liu)
• 44c2e657791681c06c58c78aa39f3b26ace54a0d Upgrade ranger dependency version with shaded dependencies (Reetika Agrawal)
• 11597ed9489287f7a3818f64bb3f68609e1cab60 Remove commented code (Svetoslav Zhelev)
• 581f52b236f94a722bee7bdd10990dc8570ac09c Throw exception in test, revert catalog config changes (Svetoslav Zhelev)
• 76084fe1f8b8e8350a1a3d03f5b1dd67bbc58cc5 Add unit tests (Svetoslav Zhelev)
• 41bf6e117b871eabc7eb33cacc9906a780f8b8a1 Implement handling of pinot binary columns (Svetoslav Zhelev)
• 5c89508cbcf2d1fbbc424963aaa8956ad4178749 Introduce pluggable PoS error classifier interface (Arjun Gupta)
• c7f43213304e52caafc01dc31841f1c36b622619 [native] Advance Velox version. (Sergey Pershin)
• faa9a649a46f32f6a162f4689e8d063295b3f924 Add TaskInfo thrift support for HttpRemoteTask (Ajay George)
• fd68d396e7d8454dcd67b0a2638d159518ce3ea5 Fix TaskResource to convert TaskInfo response to thrift (Ajay George)
• ee2269475488efbd8260a35fec6b1b75552b32a3 [native] Refactor PrestoExchangeSource to have MemoryPool (tanjialiang)
• bd2b437f01cd8704c8bb19802d54661d55a0693b Fix wrapper job conf (Arunachalam Thirupathi)
• 818adb62b2911475dcd1038c7f538a83cb2d67cb Fix bug in ORC flat map reader causing 'Read past RLE' and 'Positions must monotonically increase' errors (Sergii Druzkin)
• fd4ee4399e3151bc2d34d31517e75601d0b5b963 Add file info to exception thrown from OrcSelectiveRecordReader.OrcBlockLoader (Sergii Druzkin)
• 4b56cbccb520270e42495a9378080e1b96168538 Disable flaky presto-spark test (Pranjal Shankhdhar)
• 1fa417f25bf77ed1a9ef0fa41fda603cab66ad54 Add support for arrays and maps in VALUES clause (Masha Basmanova)
• a39144c038274c3ac9357592a8eb15539ae171c0 Enahnce error messages in AbstractTestHiveQueries (Masha Basmanova)
• 292578412204cde761e2bfbc5229088d2df3ed75 Enhance error messages in HiveExternalWorkerQueryRunner (Masha Basmanova)
• 550f8781abcf648b1b3c49a0a528bdb9c27dbe35 Fix format check targets in Makefile and delete gen-pom-xml.sh and its target (Michael Shang)
• 96fd2b8c633a299794f65afed9502ac0457307d5 [native] Fix protocol generation script. (Sergey Pershin)
• 196b6ffd829fddb46ad9843c3bc8a7df555c9db8 [native] Update linux setup script in README.md (Sergey Pershin)
• 09e50f3ff6c8234512902f5991c982ce7b95b775 Support lastDataCommitTime in commit output for metastore read queries (Lin Liu)
• 56368fb080df0dba2762a176946ac7a80f1740c4 Fix some small json issues (Michael Shang)
• 1f052f0758339e8ac3482f762326ad9263f3375c Fix NPE in FileMergeCacheManager (Arunachalam Thirupathi)
• 5b9be236abb42361d029f2cd0c83626d8e79cd0a Update README.md (Sergey Pershin)
• af6618746d03f3309eb87bd644317d537d0e9dbf [native] Add MappedMemory raw allocate related memory counterss (tanjialiang)
• 8c21937706cc8516c6450ee619ba50f91876076f Remove unused legacyMapSubscript from readers (Arunachalam Thirupathi)
• 65bb08b4c76b310077896730eed4327fe7ce9ad3 Temporarily disable macos job for native workers (Michael Shang)
• 184ee15ba1271c6a94db52e03bf2069de22106a7 Send abort results message in PrestoExchangeSource::close() (Masha Basmanova)
• 2fba5b64bf1a82f177a017033fa50d0fa06d4133 Address review comments for constraints optimization (Naveen Kumar Mahadevuni)
• 31adf7dd470abeae199ca4db9830d2b5a3d9cf75 Use requireNonNull in place of explicit null checks (Ajay George)
• d215cb3e5555594a43f7e6e72956113da5cca3fa Upgrade Delta Standalone to 0.5.0 (dnskr)
• 23dafd35ad16dc60ed3944c21f8451b63803218a Add canonicalization for table writer nodes (Pranjal Shankhdhar)
• 72ef52af28d6a5c544d986c440e983e30980fa39 Add canonicalization for limit nodes (Pranjal Shankhdhar)
• ec0b7796693e7056e37c75b904652ef0a5ee0f64 Add more gitignore for presto-native-execution (Ge Gao)
• 9c809a4a82d197c8081d85c9229b33be22da7d8a Initailize system and nodeconfig as the first step of server run. (Amit Dutta)
• f47c5fda1a2b1b94737c590b0ca9b88f090c82b8 Add getTable to HiveTableLayoutHandle (Nikhil Collooru)
• 89fc1f7564b22f945d01650ea1692b197cbd86ee Fix formatting to use %n in place of \n (Ajay George)
• 04a83b6e472b6e7df66cec624e5643a535376533 [native] Using fmt format for config directory path. (Amit Dutta)
• 8720122eacb311248a293d9c833ead8029951529 Fix method already declared error (Arunachalam Thirupathi)
• 9fab42db6c97de644ddbfd61c154733408e8ea25 Add .clang-format file. (Sergey Pershin)
• 0a158b95f71cba0ec687c6cf6b1b7fc4e320a7d1 Add canonicalization for join nodes (Pranjal Shankhdhar)
• 3180064e212e58478e8d0a6ff5424684aee7d20a Add canonical join node (Pranjal Shankhdhar)
• f2deaf9114e6143385f84703aa01f2eb76ea0efd Add getScheme() implementation in PrestoS3FileSystem.java class (pratyakshsharma)
• 8d93d32260ee1af5e191ebc0ab2fce873da5ca0c [native] Extend E2E tests for 'Arbitrary' aggregation. (Sergey Pershin)
• bb1e9383dbfcf48a36078cc19400462ef6a37915 Advance Velox version for presto-native-execution (Sergey Pershin)
• 9dbb0f9bb292ed95e62b4f268ff5bf29138ec72e Fix the exception when querying the hudi MOR table (miomiocat)
• b4641f72ad410f444ce58027545dfb60bf5f10f7 Add timeout to query analysis and planning phase (Feilong Liu)
• 673eec5e6b8852738c0a282e55d6a444fa476976 Fix a typo in the router readme (Chunxu Tang)
• 12cc6a820740ee184af355cb86245de121531593 Move more classess to presto-analyer (Rohit Jain)
• 552132b5ad3366662bfa617c3001dc42e59fb3ef Add presto-analyzer module (Rohit Jain)
• d7e6271e0035df52b5bfab24e644a32a62cddd07 Addition to 275 release notes (Reetika Agrawal)
• f77efde9df2f2589694d1608062844339a7c1e11 Velox commit advance (Michael Shang)
• fe414ed60f66cda076afecf8f00abe78960ebe9a Update CODEOWNERS (Timothy Meehan)

[pranjalssh]

@arunthirupathi yes it does :)