SQL hashing functions
InfluxDB 3 Enterprise is in Public Beta
InfluxDB 3 Enterprise is in public beta and available for testing and feedback, but is not meant for production use yet. Both the product and this documentation are works in progress. We welcome and encourage your input about your experience with the beta and invite you to join our public channels for updates and to share feedback.
Use hashing functions to hash string values in SQL queries using established hashing algorithms.
digest
Computes the binary hash of an expression using the specified algorithm.
digest(expression, algorithm)
Arguments
expression: String expression to operate on. Can be a constant, column, or function, and any combination of operators.
algorithm: String expression specifying algorithm to use. Must be one of the following:
- md5
- sha224
- sha256
- sha384
- sha512
- blake2s
- blake2b
- blake3
md5
Computes an MD5 128-bit checksum for a string expression.
md5(expression)
Arguments
- expression: String expression to operate on. Can be a constant, column, or function, and any combination of operators.
sha224
Computes the SHA-224 hash of a binary string.
sha224(expression)
Arguments
- expression: String expression to operate on. Can be a constant, column, or function, and any combination of operators.
sha256
Computes the SHA-256 hash of a binary string.
sha256(expression)
Arguments
- expression: String expression to operate on. Can be a constant, column, or function, and any combination of operators.
sha384
Computes the SHA-384 hash of a binary string.
sha384(expression)
Arguments
- expression: String expression to operate on. Can be a constant, column, or function, and any combination of operators.
sha512
Computes the SHA-512 hash of a binary string.
sha512(expression)
Arguments
- expression: String expression to operate on. Can be a constant, column, or function, and any combination of operators.
Was this page helpful?
Thank you for your feedback!
Support and feedback
Thank you for being part of our community! We welcome and encourage your feedback and bug reports for InfluxDB 3 Enterprise and this documentation. To find support, use the following resources:
Customers with an annual or support contract can contact InfluxData Support.