verticapy.sql.functions.hash#

verticapy.sql.functions.hash(*args) → StringSQL#

Calculates a hash value over the function arguments.

Parameters#

args: SQLExpression: Infinite Number of Expressions.

Returns#

StringSQL: SQL string.

Examples#

First, let’s import the vDataFrame in order to create a dummy dataset.

from verticapy import vDataFrame

Now, let’s import the VerticaPy SQL functions.

import verticapy.sql.functions as vpf

We can now build a dummy dataset.

df = vDataFrame({"x": ['banana', 'apple', 'onion', 'potato']})

Now, let’s go ahead and apply the function.

df["hash_x"] = vpf.hash(df["x"])
display(df)

	Abc x Varchar(6) 100%	123 hash_x Integer 100%
1	banana	6613216252913274229
2	apple	3671960141801938149
3	onion	5627580944735309639
4	potato	4882983939925304536

Note

It’s crucial to utilize VerticaPy SQL functions in coding, as they can be updated over time with new syntax. While SQL functions typically remain stable, they may vary across platforms or versions. VerticaPy effectively manages these changes, a task not achievable with pure SQL.