pyflink.table.Table.left_outer_join#
- Table.left_outer_join(right: pyflink.table.table.Table, join_predicate: Optional[pyflink.table.expression.Expression[bool]] = None) pyflink.table.table.Table [source]#
Joins two
Table
. Similar to a SQL left outer join. The fields of the two joined operations must not overlap, usealias()
to rename fields if necessary.Note
Both tables must be bound to the same
TableEnvironment
and itsTableConfig
must have null check enabled (default).Example:
>>> left.left_outer_join(right) >>> left.left_outer_join(right, col('a') == col('b'))
- Parameters
right – Right table.
join_predicate – Optional, the join predicate expression string.
- Returns
The result table.