hash
Compute hashcode of a string.
Get the hashcode value (double) of a column (string type).
Usage Details
select *, hash(column) as hashCode from tableName
-- column: column name to compute hash code
-- tableName: name of a table
-- returnValue: hash code value (double) of a column
Example
Input
table
| id | user |
|---|---|
| 1 | emil |
| 2 | logichub |
select *, hash(user) as hashCode from table
Output
| id | user | |
|---|---|---|
| 1 | emil | 3117003.0 |
| 2 | logichub | 2.022441175E9 |
Updated about 1 year ago