Returns the partition number of a set of values. The arguments cannot be datetime, floating-point, or DataLink values.
Example:
Use the HASH function to determine what the partitions would be if the partitioning key was composed of EMPNO and LASTNAME. This query returns the partition number for every row in EMPLOYEE.
SELECT HASH(EMPNO, LASTNAME) FROM CORPDATA.EMPLOYEE