Examples can be found at:pkg_install_location\teradataml\data\notebooks\sqlalchemy\Teradata Vantage Arithmetic Functions Using SQLAlchemy.ipynb.
Supported functions
S/N | Function Name | Description |
---|---|---|
Arithmetic Functions | ||
1 | ABS | Computes the absolute value of an argument. |
2 | CASE_N | Evaluates a list of conditions and returns the position of the first condition that evaluates to TRUE, provided that no prior condition in the list evaluates to UNKNOWN. |
3 | CEIL / CEILING | Returns the smallest integer value that is not less than the input argument. |
4 | DEGREES | DEGREES takes a value specified in radians and converts it to degrees. |
5 | RADIANS | RADIANS takes a value specified in degrees and converts it to radians. |
6 | EXP | Raises e (the base of natural logarithms) to the power of the argument, where e = 2.71828182845905. |
7 | FLOOR | Returns the largest integer equal to or less than the input argument. |
8 | LN | Computes the natural logarithm of the argument. |
9 | LOG | Computes the base 10 logarithm of an argument. |
10 | MOD | Returns the remainder (modulus) of expr1 divided by expr2. |
11 | NULLIFZERO | Converts data from zero to null to avoid problems with division by zero. |
12 | POWER | Returns base_value raised to the power of exponent_value. |
13 | ROUND | Returns numeric_value rounded places_value places to the right or left of the decimal point. |
14 | SIGN | Returns the sign of numeric_value. |
16 | SQRT | Computes the square root of an argument. |
17 | TRUNC | Returns numeric_value truncated places_value places to the right or left of the decimal point. |
18 | WIDTH_BUCKET | Returns the number of the partition to which value_expression is assigned. |
19 | ZEROIFNULL | Converts data from null to 0 to avoid cases where a null result creates an error. |
Hyperbolic Functions | ||
20 | COSH | Performs the hyperbolic or inverse hyperbolic function of an argument. |
21 | ACOSH | |
22 | SINH | |
23 | ASINH | |
24 | TANH | |
25 | ATANH | |
Trigonometric Functions | ||
26 | SIN | Performs the trigonometric or inverse trigonometric function of an argument. |
27 | ASIN | |
28 | COS | |
29 | ACOS | |
30 | TAN | |
31 | ATAN | |
32 | ATAN2 |
Unsupported functions
- RANDOM
- RANGE_N