merge
The merge
method creates a new Table
that contains the rows from all the constituent tables of this PartitionedTable
, in the same relative order as the underlying partitioned table and its constituents. If constituent tables contain extra columns not in the constituent definition, those columns will be ignored. If constituent tables are missing columns in the constituent definition, the corresponding output rows will be null.
Syntax
merge()
Parameters
This function does not take any parameters.
Returns
A new Table
that contains the rows from all the constituent tables of this PartitionedTable
, in the same relative order as the underlying partitioned table and its constituents.
Examples
source = newTable(
stringCol("X", "A", "B", "A", "C", "B", "A", "B", "B", "C"),
stringCol("Y", "M", "N", "O", "N", "P", "M", "O", "P", "M"),
intCol("Number", 55, 76, 20, 130, 230, 50, 73, 137, 214),
)
partitionedTable = source.partitionBy("X")
result = partitionedTable.merge()
- result
- source