snowflake.snowpark.functions.md5_number_lower64¶

snowflake.snowpark.functions.md5_number_lower64(msg: Union[snowflake.snowpark.column.Column, str]) → Column[source]¶

Returns a 64-bit number from the lower 64 bits of the MD5 hash of the input message.

Parameters:

msg (ColumnOrName) – The input message to hash.

Returns:

A 64-bit number representing the lower 64 bits of the MD5 hash.

Return type:

Column

Examples::

CopyExpand

>>> from snowflake.snowpark.functions import col
>>> df = session.create_dataframe([["Snowflake"], ["test"], ["hello"]], schema=["msg"])
>>> df.select(md5_number_lower64(col("msg")).alias("result")).collect()
[Row(RESULT=9203306159527282910), Row(RESULT=14618207765679027446), Row(RESULT=13362634815750784402)]

Show lessSee more

Scroll to top