Introducing AES Encryption Functions in ClickHouse
ClickHouse AES encryption functions give users a powerful tool for data security and privacy. Learn how to use AES encryption in your analytic applications.
ClickHouse AES encryption functions give users a powerful tool for data security and privacy. Learn how to use AES encryption in your analytic applications.
May 21, 2019
One of our customers recently had a problem using CickHouse: the simple workflow of load-analyze-present wasn’t as efficient as they were expecting. The body of the problem was with loading and presenting IPv4 and IPv6 addresses, which are traditionally stored in ClickHouse as UInt32 and FixedString(16) columns. These types have many advantages, like compact footprint and ease of comparing values. But they also have shortcomings that prompted us to seek a better solution.