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

id

user

1

emil

2

logichub

LQL command

select *, hash(user) as hashCode from table

Output

 

id

user

 

id

user

1

emil

3117003.0

2

logichub

2.022441175E9