Join¶

class oci.data_integration.models.Join(**kwargs)¶

Bases: oci.data_integration.models.push_down_operation.PushDownOperation

The information about the join operator. The join operator links data from multiple inbound sources.

Attributes

`MODEL_TYPE_FILTER`	str(object=’’) -> str
`MODEL_TYPE_JOIN`	str(object=’’) -> str
`MODEL_TYPE_QUERY`	str(object=’’) -> str
`MODEL_TYPE_SELECT`	str(object=’’) -> str
`MODEL_TYPE_SORT`	str(object=’’) -> str
`POLICY_FULL_JOIN`	A constant which can be used with the policy property of a Join.
`POLICY_INNER_JOIN`	A constant which can be used with the policy property of a Join.
`POLICY_LEFT_JOIN`	A constant which can be used with the policy property of a Join.
`POLICY_RIGHT_JOIN`	A constant which can be used with the policy property of a Join.
`condition`	Gets the condition of this Join.
`model_type`	[Required] Gets the model_type of this PushDownOperation.
`policy`	Gets the policy of this Join.

Methods

`__init__`(**kwargs)	Initializes a new Join object with values from keyword arguments.
`get_subtype`(object_dictionary)	Given the hash representation of a subtype of this class, use the info in the hash to return the class of the subtype.

MODEL_TYPE_FILTER = 'FILTER'¶

MODEL_TYPE_JOIN = 'JOIN'¶

MODEL_TYPE_QUERY = 'QUERY'¶

MODEL_TYPE_SELECT = 'SELECT'¶

MODEL_TYPE_SORT = 'SORT'¶

POLICY_FULL_JOIN = 'FULL_JOIN'¶: A constant which can be used with the policy property of a Join. This constant has a value of “FULL_JOIN”

POLICY_INNER_JOIN = 'INNER_JOIN'¶: A constant which can be used with the policy property of a Join. This constant has a value of “INNER_JOIN”

POLICY_LEFT_JOIN = 'LEFT_JOIN'¶: A constant which can be used with the policy property of a Join. This constant has a value of “LEFT_JOIN”

POLICY_RIGHT_JOIN = 'RIGHT_JOIN'¶: A constant which can be used with the policy property of a Join. This constant has a value of “RIGHT_JOIN”

__init__(**kwargs)¶

Initializes a new Join object with values from keyword arguments. The default value of the model_type attribute of this class is JOIN and it should not be changed. The following keyword arguments are supported (corresponding to the getters/setters of this class):

Parameters:

model_type (str) – The value to assign to the model_type property of this Join. Allowed values for this property are: “FILTER”, “JOIN”, “SELECT”, “SORT”, “QUERY”, ‘UNKNOWN_ENUM_VALUE’. Any unrecognized values returned by a service will be mapped to ‘UNKNOWN_ENUM_VALUE’.
condition (str) – The value to assign to the condition property of this Join.
policy (str) – The value to assign to the policy property of this Join. Allowed values for this property are: “INNER_JOIN”, “LEFT_JOIN”, “RIGHT_JOIN”, “FULL_JOIN”, ‘UNKNOWN_ENUM_VALUE’. Any unrecognized values returned by a service will be mapped to ‘UNKNOWN_ENUM_VALUE’.

condition¶

Gets the condition of this Join. The join condition.

Returns:	The condition of this Join.
Return type:	str

static get_subtype(object_dictionary)¶: Given the hash representation of a subtype of this class, use the info in the hash to return the class of the subtype.

model_type¶

[Required] Gets the model_type of this PushDownOperation. The type of operation.

Allowed values for this property are: “FILTER”, “JOIN”, “SELECT”, “SORT”, “QUERY”, ‘UNKNOWN_ENUM_VALUE’. Any unrecognized values returned by a service will be mapped to ‘UNKNOWN_ENUM_VALUE’.

Returns:	The model_type of this PushDownOperation.
Return type:	str

policy¶

Gets the policy of this Join. The type of join.

Allowed values for this property are: “INNER_JOIN”, “LEFT_JOIN”, “RIGHT_JOIN”, “FULL_JOIN”, ‘UNKNOWN_ENUM_VALUE’. Any unrecognized values returned by a service will be mapped to ‘UNKNOWN_ENUM_VALUE’.

Returns:	The policy of this Join.
Return type:	str