AES-128 Encryption/Decryption support in Vertica 9.0

SudhakarBSudhakarB Registered User

Does Vertica 9.0 support AES Decryption using a key natively?
I am ingesting data into Vertica that has column values that have been encrypted in different system (Hive) using a key.
I have the key, however am not able to decrypt using the key in Vertica.
I tried encryption_package from Vertica-Extension-Packages on github.

I can provide additional details, if required.
Thanks in advance.


  • Bryan_HBryan_H Employee, Registered User ✭✭

    Hi, and apologies for not seeing this sooner. My guess is that the encryption support in the C++ UDF in Vertica-Extensions is not quite the same as what is used by Hive, where our C++ UDF example is eight years old and limited in options while Hive uses the javax.crypto package.

    My guess is that you'd need to implement a Java UDF derived from the AesBase and AesDecrypt classes that Hive uses. These can be found at in the and classes.

Leave a Comment

BoldItalicStrikethroughOrdered listUnordered list
Align leftAlign centerAlign rightToggle HTML viewToggle full pageToggle lights
Drop image/file