View on GitHub

JODA - JSON On Demand Analysis

Efficient data wrangling for semi-structured JSON documents

ISNUMBER - Type

Checks whether the attribute is of numerical type

Input parameters

Name Type Optional Description
x Any False  

Output

Bool: True/False depending on check

Usage

ISNUMBER(<x>)

Examples

Example 1

Input Document

[1,2]
{"doc":1}
1
"String"
true
null

Query

LOAD tmp
AS ('': ISNUMBER(''))

Result

false
false
true
false
false
false