Select

class oci.data_integration.models.Select(**kwargs)

Bases: PushDownOperation

The information about the select object.

Attributes:

MODEL_TYPE_FILTER

A constant which can be used with the model_type property of a PushDownOperation.

MODEL_TYPE_JOIN

A constant which can be used with the model_type property of a PushDownOperation.

MODEL_TYPE_QUERY

A constant which can be used with the model_type property of a PushDownOperation.

MODEL_TYPE_SELECT

A constant which can be used with the model_type property of a PushDownOperation.

MODEL_TYPE_SORT

A constant which can be used with the model_type property of a PushDownOperation.

is_distinct

Gets the is_distinct of this Select.

model_type

[Required] Gets the model_type of this PushDownOperation.

select_columns

Gets the select_columns of this Select.

Methods:

__init__(**kwargs)

Initializes a new Select 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'

A constant which can be used with the model_type property of a PushDownOperation. This constant has a value of “FILTER”

MODEL_TYPE_JOIN = 'JOIN'

A constant which can be used with the model_type property of a PushDownOperation. This constant has a value of “JOIN”

MODEL_TYPE_QUERY = 'QUERY'

A constant which can be used with the model_type property of a PushDownOperation. This constant has a value of “QUERY”

MODEL_TYPE_SELECT = 'SELECT'

A constant which can be used with the model_type property of a PushDownOperation. This constant has a value of “SELECT”

MODEL_TYPE_SORT = 'SORT'

A constant which can be used with the model_type property of a PushDownOperation. This constant has a value of “SORT”

__init__(**kwargs)

Initializes a new Select object with values from keyword arguments. The default value of the model_type attribute of this class is SELECT 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 Select. Allowed values for this property are: “FILTER”, “JOIN”, “SELECT”, “SORT”, “QUERY”

  • is_distinct (bool) – The value to assign to the is_distinct property of this Select.

  • select_columns (list[oci.data_integration.models.ShapeField]) – The value to assign to the select_columns property of this Select.

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.

property is_distinct

Gets the is_distinct of this Select. Specifies whether the object is distinct.

Returns

The is_distinct of this Select.

Return type

bool

property 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

property select_columns

Gets the select_columns of this Select. An array of selected columns.

Returns

The select_columns of this Select.

Return type

list[oci.data_integration.models.ShapeField]