[jira] [Created] (SPARK-37586) Add cipher mode option and set default cipher mode for aes_encrypt and aes_decrypt

["Max Gekk (Jira)" <ji...@apache.org>]

Max Gekk created SPARK-37586:
--------------------------------

             Summary: Add cipher mode option and set default cipher mode for aes_encrypt and aes_decrypt
                 Key: SPARK-37586
                 URL: https://issues.apache.org/jira/browse/SPARK-37586
             Project: Spark
          Issue Type: Improvement
          Components: SQL
    Affects Versions: 3.3.0
            Reporter: Max Gekk


https://github.com/apache/spark/pull/32801 added aes_encrypt/aes_decrypt functions to spark. However they rely on the jvm's configuration regarding which cipher mode to support, this is problematic as it is not fixed across versions and systems.

Let's hardcode a default cipher mode and also allow users to set a cipher mode as an argument to the function.

In the future, we can support other modes like GCM and CBC that have been already supported by other systems:
# Snowflake: https://docs.snowflake.com/en/sql-reference/functions/encrypt.html
# Bigquery: https://cloud.google.com/bigquery/docs/reference/standard-sql/aead-encryption-concepts#block_cipher_modes



--
This message was sent by Atlassian Jira
(v8.20.1#820001)

---------------------------------------------------------------------
To unsubscribe, e-mail: issues-unsubscribe@spark.apache.org
For additional commands, e-mail: issues-help@spark.apache.org