v.20.11Experimental Feature
New Experimental Encryption Functions Added
New functionsencrypt,aes_encrypt_mysql,decrypt,aes_decrypt_mysql. These functions are working slowly, so we consider it as an experimental feature. #11844 (Vasily Nemkov).
Why it matters
These functions enable users to encrypt and decrypt data directly in ClickHouse, facilitating data security and confidentiality. Although currently slow and experimental, they provide foundational support for cryptographic operations inside ClickHouse to protect sensitive information.How to use it
Use the functionsencrypt and aes_encrypt_mysql to encrypt data, and decrypt and aes_decrypt_mysql to decrypt it within SQL queries. Since these functions are experimental and performance is slow, they should be used with caution in production workloads.