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]) –

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

pu_function instance-attribute

pu_function: str

query_string property

query_string: str

Returns query string.

PullUpAvgOperator

Bases: PullUpOperator

Pull up operator that computes mean of column.

Applies PU_AVG operator to column.

pu_function instance-attribute class-attribute

pu_function: str = 'PU_AVG'

PullUpSumOperator

Bases: PullUpOperator

Pull up operator that computes sum of column.

Applies PU_SUM operator to column.

pu_function instance-attribute class-attribute

pu_function: str = 'PU_SUM'

PullUpProductOperator

Bases: PullUpOperator

Pull up operator that computes product of column.

Applies PU_PRODUCT operator to column.

pu_function instance-attribute class-attribute

pu_function: str = 'PU_PRODUCT'

PullUpCountOperator

Bases: PullUpOperator

Pull up operator that computes count of column.

Applies PU_COUNT operator to column.

pu_function instance-attribute class-attribute

pu_function: str = 'PU_COUNT'

PullUpCountDistinctOperator

Bases: PullUpOperator

Pull up operator that computes distinct counts of column.

Applies PU_COUNT_DISTINCT operator to column.

pu_function instance-attribute class-attribute

pu_function: str = 'PU_COUNT_DISTINCT'

PullUpMinOperator

Bases: PullUpOperator

Pull up operator that computes min of column.

Applies PU_MIN operator to column.

pu_function instance-attribute class-attribute

pu_function: str = 'PU_MIN'

PullUpMaxOperator

Bases: PullUpOperator

Pull up operator that computes max of column.

Applies PU_MAX operator to column.

pu_function instance-attribute class-attribute

pu_function: str = 'PU_MAX'

PullUpMedianOperator

Bases: PullUpOperator

Pull up operator that computes median of column.

Applies PU_MEDIAN operator to column.

pu_function instance-attribute class-attribute

pu_function: str = 'PU_MEDIAN'

PullUpModeOperator

Bases: PullUpOperator

Pull up operator that computes mode of column.

Applies PU_MODE operator to column.

pu_function instance-attribute class-attribute

pu_function: str = 'PU_MODE'

PullUpStandardDeviationOperator

Bases: PullUpOperator

Pull up operator that computes standard deviation of column.

Applies PU_STDEV operator to column.

pu_function instance-attribute class-attribute

pu_function: str = 'PU_STDEV'