snowflake.snowpark.functions.md5_number_upper64

snowflake.snowpark.functions.md5_number_upper64(msg: Union[snowflake.snowpark.column.Column, str]) → Column[source] (https://github.com/snowflakedb/snowpark-python/blob/v1.43.0/src/snowflake/snowpark/_functions/scalar_functions.py#L4140-L4158)

Returns the upper 64 bits of the MD5 hash of the input message as a number.

Parameters:

msg (ColumnOrName) – The input message to hash.

Returns:

A column containing the upper 64 bits of the MD5 hash as a number.

Return type:

Column

Examples::
>>> from snowflake.snowpark.functions import col
>>> df = session.create_dataframe([["Snowflake"], ["test"], ["hello"]], schema=["msg"])
>>> df.select(md5_number_upper64(col("msg")).alias("result")).collect()
[Row(RESULT=17145559544104499780), Row(RESULT=688887797400064883), Row(RESULT=6719722671305337462)]
Copy
Language: English