qidaye opened a new issue #5954:
URL: https://github.com/apache/incubator-doris/issues/5954
# Data encrypt/decrypt
Many users' sensitive data needs to be stored with data encryption to
prevent eavesdropping and interception during transmission, such as banks.
# Design
1. Supports common encryption and decryption and message digest algorithms
2. Key cannot appear in the function plaintext
Implement the syntax for creating a key or public key, and use the
`key:key_name` instead of the key.
# Detailed Design
## Syntax
The main changes involved here include.
1. implement the class for create/show/drop keys
2. persist the key to the database, involving catalog-related changes
3. parse the key_name as a string when using
```sql
CREATE KEYSTORE my_key AS "abcd12345";
SHOW KEYSTORES;
DROP KEYSTORE my_key;
SELECT HEX(AES_ENCRYPT("Doris is Great", "key:my_key"));
SELECT AES_DECRYPT(UNHEX('162C1928440DEB6EBFD6DF0FD60BB3C3'), "key:my_key");
```
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
For queries about this service, please contact Infrastructure at:
[email protected]
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
