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