Skip to main content

UNION

Combine rows from multiple datasets.

Syntax​

UNION fromClause (, fromClause)*

Parameters​

  • fromClause - A dataset reference or table alias assignment

Description​

The UNION command combines rows from multiple datasets into a single output stream. The command performs type expansion on input datasets, automatically creating a unified schema that accommodates all fields from all sources. Missing fields in any dataset are filled with null values. All rows from each input dataset are preserved without deduplication.