You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@doris.apache.org by GitBox <gi...@apache.org> on 2021/06/02 05:12:50 UTC

[GitHub] [incubator-doris] qidaye opened a new issue #5954: [Proposal] support data encrypt/decrypt

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:
users@infra.apache.org



---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For additional commands, e-mail: commits-help@doris.apache.org

[GitHub] [incubator-doris] qidaye closed issue #5954: [Proposal] support data encrypt/decrypt

Posted by GitBox <gi...@apache.org>.
qidaye closed issue #5954:
URL: https://github.com/apache/incubator-doris/issues/5954


   


-- 
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:
users@infra.apache.org



---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For additional commands, e-mail: commits-help@doris.apache.org

[GitHub] [incubator-doris] morningman closed issue #5954: [Proposal] support data encrypt/decrypt

Posted by GitBox <gi...@apache.org>.
morningman closed issue #5954:
URL: https://github.com/apache/incubator-doris/issues/5954


   


-- 
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.

To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org



---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For additional commands, e-mail: commits-help@doris.apache.org