join

pylibcudf.join.conditional_full_join(Table left, Table right, Expression binary_predicate) → tuple

Perform a conditional full join between two tables.

For details, see conditional_full_join().

Parameters:

leftTable

The left table to join.

rightTable

The right table to join.

binary_predicateExpression

Condition to join on.

Returns:

Tuple[Column, Column]

A tuple containing the row indices from the left and right tables after the join.

pylibcudf.join.conditional_inner_join(Table left, Table right, Expression binary_predicate) → tuple

Perform a conditional inner join between two tables.

For details, see conditional_inner_join().

Parameters:

leftTable

The left table to join.

rightTable

The right table to join.

binary_predicateExpression

Condition to join on.

Returns:

Tuple[Column, Column]

A tuple containing the row indices from the left and right tables after the join.

pylibcudf.join.conditional_left_anti_join(Table left, Table right, Expression binary_predicate) → Column

Perform a conditional left anti join between two tables.

For details, see conditional_left_anti_join().

Parameters:

leftTable

The left table to join.

rightTable

The right table to join.

binary_predicateExpression

Condition to join on.

Returns:

Column

A column containing the row indices from the left table after the join.

pylibcudf.join.conditional_left_join(Table left, Table right, Expression binary_predicate) → tuple

Perform a conditional left join between two tables.

For details, see conditional_left_join().

Parameters:

leftTable

The left table to join.

rightTable

The right table to join.

binary_predicateExpression

Condition to join on.

Returns:

Tuple[Column, Column]

A tuple containing the row indices from the left and right tables after the join.

pylibcudf.join.conditional_left_semi_join(Table left, Table right, Expression binary_predicate) → Column

Perform a conditional left semi join between two tables.

For details, see conditional_left_semi_join().

Parameters:

leftTable

The left table to join.

rightTable

The right table to join.

binary_predicateExpression

Condition to join on.

Returns:

Column

A column containing the row indices from the left table after the join.

pylibcudf.join.cross_join(Table left, Table right) → Table

Perform a cross join on two tables.

For details see cross_join().

Parameters:

leftTable

The left table to join.

right: Table

The right table to join.

Returns:

Table

The result of cross joining the two inputs.

pylibcudf.join.full_join(Table left_keys, Table right_keys, null_equality nulls_equal) → tuple

Perform a full join between two tables.

For details, see full_join().

Parameters:

left_keysTable

The left table to join.

right_keysTable

The right table to join.

nulls_equalNullEquality

Should nulls compare equal?

Returns:

Tuple[Column, Column]

A tuple containing the row indices from the left and right tables after the join.

pylibcudf.join.inner_join(Table left_keys, Table right_keys, null_equality nulls_equal) → tuple

Perform an inner join between two tables.

For details, see inner_join().

Parameters:

left_keysTable

The left table to join.

right_keysTable

The right table to join.

nulls_equalNullEquality

Should nulls compare equal?

Returns:

Tuple[Column, Column]

A tuple containing the row indices from the left and right tables after the join.

pylibcudf.join.left_anti_join(Table left_keys, Table right_keys, null_equality nulls_equal) → Column

Perform a left anti join between two tables.

For details, see left_anti_join().

Parameters:

left_keysTable

The left table to join.

right_keysTable

The right table to join.

nulls_equalNullEquality

Should nulls compare equal?

Returns:

Column

A column containing the row indices from the left table after the join.

pylibcudf.join.left_join(Table left_keys, Table right_keys, null_equality nulls_equal) → tuple

Perform a left join between two tables.

For details, see left_join().

Parameters:

left_keysTable

The left table to join.

right_keysTable

The right table to join.

nulls_equalNullEquality

Should nulls compare equal?

Returns:

Tuple[Column, Column]

A tuple containing the row indices from the left and right tables after the join.

pylibcudf.join.left_semi_join(Table left_keys, Table right_keys, null_equality nulls_equal) → Column

Perform a left semi join between two tables.

For details, see left_semi_join().

Parameters:

left_keysTable

The left table to join.

right_keysTable

The right table to join.

nulls_equalNullEquality

Should nulls compare equal?

Returns:

Column

A column containing the row indices from the left table after the join.

pylibcudf.join.mixed_full_join(Table left_keys, Table right_keys, Table left_conditional, Table right_conditional, Expression binary_predicate, null_equality nulls_equal) → tuple

Perform a mixed full join between two tables.

For details, see mixed_full_join().

Parameters:

left_keysTable

The left table to use for the equality join.

right_keysTable

The right table to use for the equality join.

left_conditionalTable

The left table to use for the conditional join.

right_conditionalTable

The right table to use for the conditional join.

binary_predicateExpression

Condition to join on.

nulls_equalNullEquality

Should nulls compare equal in the equality join?

Returns:

Tuple[Column, Column]

A tuple containing the row indices from the left and right tables after the join.

pylibcudf.join.mixed_inner_join(Table left_keys, Table right_keys, Table left_conditional, Table right_conditional, Expression binary_predicate, null_equality nulls_equal) → tuple

Perform a mixed inner join between two tables.

For details, see mixed_inner_join().

Parameters:

left_keysTable

The left table to use for the equality join.

right_keysTable

The right table to use for the equality join.

left_conditionalTable

The left table to use for the conditional join.

right_conditionalTable

The right table to use for the conditional join.

binary_predicateExpression

Condition to join on.

nulls_equalNullEquality

Should nulls compare equal in the equality join?

Returns:

Tuple[Column, Column]

A tuple containing the row indices from the left and right tables after the join.

pylibcudf.join.mixed_left_anti_join(Table left_keys, Table right_keys, Table left_conditional, Table right_conditional, Expression binary_predicate, null_equality nulls_equal) → Column

Perform a mixed left anti join between two tables.

For details, see mixed_left_anti_join().

Parameters:

left_keysTable

The left table to use for the equality join.

right_keysTable

The right table to use for the equality join.

left_conditionalTable

The left table to use for the conditional join.

right_conditionalTable

The right table to use for the conditional join.

binary_predicateExpression

Condition to join on.

nulls_equalNullEquality

Should nulls compare equal in the equality join?

Returns:

Column

A column containing the row indices from the left table after the join.

pylibcudf.join.mixed_left_join(Table left_keys, Table right_keys, Table left_conditional, Table right_conditional, Expression binary_predicate, null_equality nulls_equal) → tuple

Perform a mixed left join between two tables.

For details, see mixed_left_join().

Parameters:

left_keysTable

The left table to use for the equality join.

right_keysTable

The right table to use for the equality join.

left_conditionalTable

The left table to use for the conditional join.

right_conditionalTable

The right table to use for the conditional join.

binary_predicateExpression

Condition to join on.

nulls_equalNullEquality

Should nulls compare equal in the equality join?

Returns:

Tuple[Column, Column]

A tuple containing the row indices from the left and right tables after the join.

pylibcudf.join.mixed_left_semi_join(Table left_keys, Table right_keys, Table left_conditional, Table right_conditional, Expression binary_predicate, null_equality nulls_equal) → Column

Perform a mixed left semi join between two tables.

For details, see mixed_left_semi_join().

Parameters:

left_keysTable

The left table to use for the equality join.

right_keysTable

The right table to use for the equality join.

left_conditionalTable

The left table to use for the conditional join.

right_conditionalTable

The right table to use for the conditional join.

binary_predicateExpression

Condition to join on.

nulls_equalNullEquality

Should nulls compare equal in the equality join?

Returns:

Column

A column containing the row indices from the left table after the join.