path_exists(object: object, path: string) -> bool

Given a column and path, return whether the JSON path exists in that column. Must have a valid column.

Domain

This is a scalar function (calculates a single output value for a single input row).

Categories

• Boolean
• Semistructured

Examples

path_exists(A, 'C')

Returns whether JSON path 'C' exists in column A.

path_exists(A, 'B.C')

Returns whether JSON path 'B.C' exists in column A. A value containing the path may be { B: { C: 1 } }.

path_exists(@aaa.B, 'C')

Returns whether JSON path 'C' exists in column B of input aaa. Referencing non-default inputs only works in join verb projection expressions.