MD5SUM_NUMERIC (Lakehouse v2)

Returns the MD5 hash of multiple strings as a 128-bit numeric value.

Analyze Syntax

func.md5sum_numeric(<str1>[, <str2>, ...])

Analyze Examples

func.md5sum_numeric('hello')

┌────────────┐
│ (largeint)  │
└────────────┘

SQL Syntax

MD5SUM_NUMERIC(<str1>[, <str2>, ...])

SQL Examples

SELECT MD5SUM_NUMERIC('hello');

┌─────────────────────────────────────────┐
│ 268224579284945131320661290344218476706  │
└─────────────────────────────────────────┘