unionallΒΆ

unionall command appends the rows of the streams specified as an argument to the input stream:

unionAll( query_input_cmd [ ,... ] )

where query_input_cmd can be any of the query input commands.

Note

When the streams have a different set of fields then the resulting stream has a combination of all the fields, where values of fields missing in the original stream are evaluated to NULL.

Example:

1
2
3
4
5
@s1 = dual(3) | select(i, s);

dual(3,3) | select(i, ip)
| unionall(@s1)
;
i ip s
3 0.0.0.3 NULL
4 0.0.0.4 NULL
5 0.0.0.5 NULL
0 NULL 0ho0
1 NULL 1ho1
2 NULL 2ho2