[SPARK-42701] Add the try_aes_decrypt() function

• Type: New Feature
• Status: Resolved
• Priority: Major
• Resolution: Fixed
• Affects Version/s: 3.4.0
• Fix Version/s: 3.5.0
• Component/s: SQL
• Labels: starter
• Assignee: Max Gekk
• Reporter: Max Gekk
• Shepherd: Max Gekk
• Created: 07/Mar/23 13:05
• Updated: 09/Mar/23 06:13
• Resolved: 09/Mar/23 06:13

Description

Add new function try_aes_decrypt(). The function aes_decrypt() fails w/ an exception when it faces to a column value which it cannot decrypt. So, if a column contains bad and good input, it is impossible to decrypt even good input.

Issue Links

• relates to: SPARK-37858 Throw Spark exceptions from AES functions
• links to: [Github] Pull Request #40340 (MaxGekk)