ETL: IsEmpty

Check if a map or bag is empty, returning true, false, or null accordingly. Use ISEMPTY for conditional logic and data validation in ETL pipelines.

Description

Returns true if the input map or bag is empty, false if the input contains items, or null if the input is null.

Syntax

IsEmpty(input_arg)

Arguments

input_arg (string) - Bag or map argument.

Examples

IsEmpty(JsonStringToBag('[1,2,3]')) returns false
IsEmpty(JsonStringToBag('[]')) returns true
IsEmpty(JsonStringToBag('')) returns null

Return value datatype

boolean

Impact of null value

If input is null, null is returned.