unionAll#

swordfish.function.unionAll()#

For the first scenario, combine 2 tables into a single table. The result is an unpartitioned in-memory table.

For the second scenario, combine multiple tables into a single table. If partitioned is set to “false”, the result is an unpartitioned in-memory table; if partitioned is set to “true”, the result is a partitioned in-memory table with sequential domain. The default value is “true”.

If byColName =false, all tables to be combined must have identical number of columns.

If byColName =true, the tables to be combined can have different number of columns. If a column does not exist in a table, it is filled with null values in the final result.

Parameters:

  • tableA (Union[Alias[Literal["tables"]], Constant]) – A table.

  • tableB (Union[Alias[Literal["partition"]], Constant], optional) – A table, by default DFLT

  • byColName (Constant, optional) – A Boolean value indicating whether the table combination is conducted along columns with the same name, by default DFLT.

On this page