core.0.45.1.source-code.functions_arithmetic_decimal.yaml Maven / Gradle / Ivy
Go to download
Show more of this group Show more artifacts with this name
Show all versions of core Show documentation
Show all versions of core Show documentation
Create a well-defined, cross-language specification for data compute operations
%YAML 1.2
---
scalar_functions:
-
name: "add"
description: "Add two decimal values."
impls:
- args:
- name: x
value: decimal
- name: y
value: decimal
options:
overflow:
values: [ SILENT, SATURATE, ERROR ]
return: |-
init_scale = max(S1,S2)
init_prec = init_scale + max(P1 - S1, P2 - S2) + 1
min_scale = min(init_scale, 6)
delta = init_prec - 38
prec = min(init_prec, 38)
scale_after_borrow = max(init_scale - delta, min_scale)
scale = init_prec > 38 ? scale_after_borrow : init_scale
DECIMAL
-
name: "subtract"
impls:
- args:
- name: x
value: decimal
- name: y
value: decimal
options:
overflow:
values: [ SILENT, SATURATE, ERROR ]
return: |-
init_scale = max(S1,S2)
init_prec = init_scale + max(P1 - S1, P2 - S2) + 1
min_scale = min(init_scale, 6)
delta = init_prec - 38
prec = min(init_prec, 38)
scale_after_borrow = max(init_scale - delta, min_scale)
scale = init_prec > 38 ? scale_after_borrow : init_scale
DECIMAL
-
name: "multiply"
impls:
- args:
- name: x
value: decimal
- name: y
value: decimal
options:
overflow:
values: [ SILENT, SATURATE, ERROR ]
return: |-
init_scale = S1 + S2
init_prec = P1 + P2 + 1
min_scale = min(init_scale, 6)
delta = init_prec - 38
prec = min(init_prec, 38)
scale_after_borrow = max(init_scale - delta, min_scale)
scale = init_prec > 38 ? scale_after_borrow : init_scale
DECIMAL
-
name: "divide"
impls:
- args:
- name: x
value: decimal
- name: y
value: decimal
options:
overflow:
values: [ SILENT, SATURATE, ERROR ]
return: |-
init_scale = max(6, S1 + P2 + 1)
init_prec = P1 - S1 + P2 + init_scale
min_scale = min(init_scale, 6)
delta = init_prec - 38
prec = min(init_prec, 38)
scale_after_borrow = max(init_scale - delta, min_scale)
scale = init_prec > 38 ? scale_after_borrow : init_scale
DECIMAL
-
name: "modulus"
impls:
- args:
- name: x
value: decimal
- name: y
value: decimal
options:
overflow:
values: [ SILENT, SATURATE, ERROR ]
return: |-
init_scale = max(S1,S2)
init_prec = min(P1 - S1, P2 - S2) + init_scale
min_scale = min(init_scale, 6)
delta = init_prec - 38
prec = min(init_prec, 38)
scale_after_borrow = max(init_scale - delta, min_scale)
scale = init_prec > 38 ? scale_after_borrow : init_scale
DECIMAL
-
name: "abs"
description: Calculate the absolute value of the argument.
impls:
- args:
- name: x
value: decimal
return: decimal
- name: "bitwise_and"
description: >
Return the bitwise AND result for two decimal inputs.
In inputs scale must be 0 (i.e. only integer types are allowed)
impls:
- args:
- name: x
value: "DECIMAL"
- name: y
value: "DECIMAL"
return: |-
max_precision = max(P1, P2)
DECIMAL
- name: "bitwise_or"
description: >
Return the bitwise OR result for two given decimal inputs.
In inputs scale must be 0 (i.e. only integer types are allowed)
impls:
- args:
- name: x
value: "DECIMAL"
- name: y
value: "DECIMAL"
return: |-
max_precision = max(P1, P2)
DECIMAL
- name: "bitwise_xor"
description: >
Return the bitwise XOR result for two given decimal inputs.
In inputs scale must be 0 (i.e. only integer types are allowed)
impls:
- args:
- name: x
value: "DECIMAL"
- name: y
value: "DECIMAL"
return: |-
max_precision = max(P1, P2)
DECIMAL
- name: "sqrt"
description: Square root of the value. Sqrt of 0 is 0 and sqrt of negative values will raise an error.
impls:
- args:
- name: x
value: "DECIMAL"
return: fp64
- name: "factorial"
description: >
Return the factorial of a given decimal input. Scale should be 0 for factorial decimal input.
The factorial of 0! is 1 by convention. Negative inputs will raise an error.
Input which cause overflow of result will raise an error.
impls:
- args:
- name: "n"
value: "DECIMAL"
return: "DECIMAL<38,0>"
-
name: "power"
description: "Take the power with x as the base and y as exponent.
Behavior for complex number result is indicated by option complex_number_result"
impls:
- args:
- name: x
value: "DECIMAL"
- name: y
value: "DECIMAL"
options:
overflow:
values: [ SILENT, SATURATE, ERROR ]
complex_number_result:
values: [ NAN, ERROR ]
return: fp64
aggregate_functions:
- name: "sum"
description: Sum a set of values.
impls:
- args:
- name: x
value: "DECIMAL"
options:
overflow:
values: [ SILENT, SATURATE, ERROR ]
nullability: DECLARED_OUTPUT
decomposable: MANY
intermediate: "DECIMAL?<38,S>"
return: "DECIMAL?<38,S>"
- name: "avg"
description: Average a set of values.
impls:
- args:
- name: x
value: "DECIMAL"
options:
overflow:
values: [ SILENT, SATURATE, ERROR ]
nullability: DECLARED_OUTPUT
decomposable: MANY
intermediate: "STRUCT,i64>"
return: "DECIMAL<38,S>"
- name: "min"
description: Min a set of values.
impls:
- args:
- name: x
value: "DECIMAL"
nullability: DECLARED_OUTPUT
decomposable: MANY
intermediate: "DECIMAL?"
return: "DECIMAL?"
- name: "max"
description: Max a set of values.
impls:
- args:
- name: x
value: "DECIMAL"
nullability: DECLARED_OUTPUT
decomposable: MANY
intermediate: "DECIMAL?"
return: "DECIMAL?"
- name: "sum0"
description: >
Sum a set of values. The sum of zero elements yields zero.
Null values are ignored.
impls:
- args:
- name: x
value: "DECIMAL"
options:
overflow:
values: [ SILENT, SATURATE, ERROR ]
nullability: DECLARED_OUTPUT
decomposable: MANY
intermediate: "DECIMAL<38,S>"
return: "DECIMAL<38,S>"
© 2015 - 2024 Weber Informatics LLC | Privacy Policy