ETL: TOBAG

Convert one or more expressions into a bag (array) data type. Use TOBAG for creating collections from individual values in ETL data pipelines.

Description

Converts one or more expressions to type bag.

Syntax

TOBAG(expression[,expression...])

Examples

TOBAG('Alan','64','1.88') returns {(Alan),(64),(1.88)}.

Return value datatype

Bag

Impact of null value

If input is null, returns null.