View on GitHub

JODA - JSON On Demand Analysis

Efficient data wrangling for semi-structured JSON documents

HASH - Misc

Computes a hash value of the given value

Details

In case of arrays or objects, the hash is calculated for the complete subtree. Hence, the hash value can be used to check jsonify objects for equality.

Input parameters

Name Type Optional Description
x Any False  

Output

Number: a hash number, representing the underlying value

Usage

HASH(<x>)

Examples

Example 1

Input Document

1
-4
5.6
"  -123.3543  "
true
false
[1,2,3]
{"doc":1} 

Query

LOAD tmp
AS ('': HASH(''))

Result

2654435770
2654435765
15434769447420412623
15361542772138653858
2654435770
2654435769
11093822460243
7615289692239180477