Join

class oci.data_connectivity.models.Join(**kwargs)

Bases: oci.data_connectivity.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 [Required] Gets the condition of this Join.
model_type [Required] Gets the model_type of this PushDownOperation.
policy [Required] 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”
  • 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”
condition

[Required] 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”

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

[Required] Gets the policy of this Join. The type of join.

Allowed values for this property are: “INNER_JOIN”, “LEFT_JOIN”, “RIGHT_JOIN”, “FULL_JOIN”

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