Document toolboxDocument toolbox

hash

Get the hashcode value (double) of a column (string type).

Usage Details

LQL Command

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
1emil
2logichub

LQL command

select *, hash(user) as hashCode from table

Output

id user
1emil3117003.0
2logichub2.022441175E9