Arithmetic, Hyperbolic and Trigonometric Functions | SQLAlchemy | teradataml - Arithmetic, Hyperbolic and Trigonometric Functions - Teradata Vantage

Teradata® VantageCloud Lake

Deployment
VantageCloud
Edition
Lake
Product
Teradata Vantage
Published
January 2023
Language
English (United States)
Last Update
2024-02-17
dita:mapPath
phg1621910019905.ditamap
dita:ditavalPath
pny1626732985837.ditaval
dita:id
phg1621910019905
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