pull_up_aggregation

PullUpOperator

PullUpOperator(
    operand, target_table, filter_expression=None
)

Bases: UnaryPQLOperator, ABC

Base class for pull up operators.

Parameters:

• operand (Union[ScalarValue, PQLOperator]) –

  Operand to which pull up function is applied.

• target_table (str) –

  The table to which the aggregation result should be pulled.

• filter_expression (Optional[str], default: None ) –

  An optional filter expression to specify which values of the source table should be taken into account for the aggregation.

is_boolean class-attribute instance-attribute

is_boolean = False

pu_function instance-attribute

pu_function

query_string property

query_string

Returns query string.

PullUpAvgOperator

PullUpAvgOperator(
    operand, target_table, filter_expression=None
)

Bases: PullUpOperator

Pull up operator that computes mean of column.

Applies PU_AVG operator to column.

Parameters:

• operand (Union[ScalarValue, PQLOperator]) –

  Operand to which pull up function is applied.

• target_table (str) –

  The table to which the aggregation result should be pulled.

• filter_expression (Optional[str], default: None ) –

  An optional filter expression to specify which values of the source table should be taken into account for the aggregation.

is_boolean class-attribute instance-attribute

is_boolean = False

query_string property

query_string

Returns query string.

pu_function class-attribute instance-attribute

pu_function = 'PU_AVG'

PullUpSumOperator

PullUpSumOperator(
    operand, target_table, filter_expression=None
)

Bases: PullUpOperator

Pull up operator that computes sum of column.

Applies PU_SUM operator to column.

Parameters:

• operand (Union[ScalarValue, PQLOperator]) –

  Operand to which pull up function is applied.

• target_table (str) –

  The table to which the aggregation result should be pulled.

• filter_expression (Optional[str], default: None ) –

  An optional filter expression to specify which values of the source table should be taken into account for the aggregation.

is_boolean class-attribute instance-attribute

is_boolean = False

query_string property

query_string

Returns query string.

pu_function class-attribute instance-attribute

pu_function = 'PU_SUM'

PullUpProductOperator

PullUpProductOperator(
    operand, target_table, filter_expression=None
)

Bases: PullUpOperator

Pull up operator that computes product of column.

Applies PU_PRODUCT operator to column.

Parameters:

• operand (Union[ScalarValue, PQLOperator]) –

  Operand to which pull up function is applied.

• target_table (str) –

  The table to which the aggregation result should be pulled.

• filter_expression (Optional[str], default: None ) –

  An optional filter expression to specify which values of the source table should be taken into account for the aggregation.

is_boolean class-attribute instance-attribute

is_boolean = False

query_string property

query_string

Returns query string.

pu_function class-attribute instance-attribute

pu_function = 'PU_PRODUCT'

PullUpCountOperator

PullUpCountOperator(
    operand, target_table, filter_expression=None
)

Bases: PullUpOperator

Pull up operator that computes count of column.

Applies PU_COUNT operator to column.

Parameters:

• operand (Union[ScalarValue, PQLOperator]) –

  Operand to which pull up function is applied.

• target_table (str) –

  The table to which the aggregation result should be pulled.

• filter_expression (Optional[str], default: None ) –

  An optional filter expression to specify which values of the source table should be taken into account for the aggregation.

is_boolean class-attribute instance-attribute

is_boolean = False

query_string property

query_string

Returns query string.

pu_function class-attribute instance-attribute

pu_function = 'PU_COUNT'

PullUpCountDistinctOperator

PullUpCountDistinctOperator(
    operand, target_table, filter_expression=None
)

Bases: PullUpOperator

Pull up operator that computes distinct counts of column.

Applies PU_COUNT_DISTINCT operator to column.

Parameters:

• operand (Union[ScalarValue, PQLOperator]) –

  Operand to which pull up function is applied.

• target_table (str) –

  The table to which the aggregation result should be pulled.

• filter_expression (Optional[str], default: None ) –

  An optional filter expression to specify which values of the source table should be taken into account for the aggregation.

is_boolean class-attribute instance-attribute

is_boolean = False

query_string property

query_string

Returns query string.

pu_function class-attribute instance-attribute

pu_function = 'PU_COUNT_DISTINCT'

PullUpMinOperator

PullUpMinOperator(
    operand, target_table, filter_expression=None
)

Bases: PullUpOperator

Pull up operator that computes min of column.

Applies PU_MIN operator to column.

Parameters:

• operand (Union[ScalarValue, PQLOperator]) –

  Operand to which pull up function is applied.

• target_table (str) –

  The table to which the aggregation result should be pulled.

• filter_expression (Optional[str], default: None ) –

  An optional filter expression to specify which values of the source table should be taken into account for the aggregation.

is_boolean class-attribute instance-attribute

is_boolean = False

query_string property

query_string

Returns query string.

pu_function class-attribute instance-attribute

pu_function = 'PU_MIN'

PullUpMaxOperator

PullUpMaxOperator(
    operand, target_table, filter_expression=None
)

Bases: PullUpOperator

Pull up operator that computes max of column.

Applies PU_MAX operator to column.

Parameters:

• operand (Union[ScalarValue, PQLOperator]) –

  Operand to which pull up function is applied.

• target_table (str) –

  The table to which the aggregation result should be pulled.

• filter_expression (Optional[str], default: None ) –

  An optional filter expression to specify which values of the source table should be taken into account for the aggregation.

is_boolean class-attribute instance-attribute

is_boolean = False

query_string property

query_string

Returns query string.

pu_function class-attribute instance-attribute

pu_function = 'PU_MAX'

PullUpMedianOperator

PullUpMedianOperator(
    operand, target_table, filter_expression=None
)

Bases: PullUpOperator

Pull up operator that computes median of column.

Applies PU_MEDIAN operator to column.

Parameters:

• operand (Union[ScalarValue, PQLOperator]) –

  Operand to which pull up function is applied.

• target_table (str) –

  The table to which the aggregation result should be pulled.

• filter_expression (Optional[str], default: None ) –

  An optional filter expression to specify which values of the source table should be taken into account for the aggregation.

is_boolean class-attribute instance-attribute

is_boolean = False

query_string property

query_string

Returns query string.

pu_function class-attribute instance-attribute

pu_function = 'PU_MEDIAN'

PullUpModeOperator

PullUpModeOperator(
    operand, target_table, filter_expression=None
)

Bases: PullUpOperator

Pull up operator that computes mode of column.

Applies PU_MODE operator to column.

Parameters:

• operand (Union[ScalarValue, PQLOperator]) –

  Operand to which pull up function is applied.

• target_table (str) –

  The table to which the aggregation result should be pulled.

• filter_expression (Optional[str], default: None ) –

  An optional filter expression to specify which values of the source table should be taken into account for the aggregation.

is_boolean class-attribute instance-attribute

is_boolean = False

query_string property

query_string

Returns query string.

pu_function class-attribute instance-attribute

pu_function = 'PU_MODE'

PullUpStandardDeviationOperator

PullUpStandardDeviationOperator(
    operand, target_table, filter_expression=None
)

Bases: PullUpOperator

Pull up operator that computes standard deviation of column.

Applies PU_STDEV operator to column.

Parameters:

• operand (Union[ScalarValue, PQLOperator]) –

  Operand to which pull up function is applied.

• target_table (str) –

  The table to which the aggregation result should be pulled.

• filter_expression (Optional[str], default: None ) –

  An optional filter expression to specify which values of the source table should be taken into account for the aggregation.

is_boolean class-attribute instance-attribute

is_boolean = False

query_string property

query_string

Returns query string.

pu_function class-attribute instance-attribute

pu_function = 'PU_STDEV'