You are viewing documentation about an older version (1.45.0). View latest version

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.45.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)]