Arithmetic, Hyperbolic and Trigonometric Functions | SQLAlchemy | teradataml - Arithmetic, Hyperbolic and Trigonometric Functions - Teradata Package for Python

Teradata® Package for Python User Guide

Product
Teradata Package for Python
Release Number
17.00
Published
November 2021
Language
English (United States)
Last Update
2022-01-14
dita:mapPath
bol1585763678431.ditamap
dita:ditavalPath
ayr1485454803741.ditaval
dita:id
B700-4006
lifecycle
previous
Product Category
Teradata Vantage
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