tencent cloud

All product documents
Cloud Log Service
DocumentationCloud Log ServiceOperation GuideSearch and Analysis (Log Topic)Statistical Analysis (SQL)SQL FunctionsMathematical Calculation Functions
Mathematical Calculation Functions
Download PDF
Last updated: 2024-03-20 11:47:49
Mathematical Calculation Functions
Last updated: 2024-03-20 11:47:49
Download PDF
This document introduces the basic syntax and examples of mathematical calculation functions.
CLS's log analysis feature allows you to analyze logs by analyzing fields of int, long, and double types via mathematical calculation functions and mathematical statistical functions.
Note:
Mathematical calculation functions support operators +-*/%.
x and y in the following functions can be numbers, log fields, or expressions with numerical calculation results.

Basic Syntax

Function
Description
abs(x)
Returns the absolute value of x.
cbrt(x)
Returns the cube root of x.
sqrt(x)
Returns the square root of x.
cosine_similarity(x,y)
Returns the cosine similarity between the vectors x and y.
For example, * | SELECT cosine_similarity(MAP(ARRAY['x','y'], ARRAY[1.0,0.0]), MAP(ARRAY['x','y'], ARRAY[0.0,1.0])) returns 0.
degrees(x)
Converts angle x in radians to degrees.
radians(x)
Converts angle x in degrees to radians.
e()
Returns the natural logarithm of the number.
exp(x)
Returns the exponent of the natural logarithm.
ln(x)
Returns the natural logarithm of x.
log2(x)
Returns the base-2 logarithm of x.
log10(x)
Returns the base-10 logarithm of x.
log(x,b)
Returns the base-b logarithm of x.
pi()
Returns the value of Pi, accurate to 14 decimal places.
pow(x,b)
Returns x raised to the power of b.
rand()
Returns a random value.
random(0,n)
Returns a random number within the [0,n) range.
round(x)
Returns the rounded value of x.
round(x, N)
Returns x rounded to N decimal places.
floor(x)
Returns x rounded down to the nearest integer.
ceiling(x)
Returns x rounded up to the nearest integer.
from_base(varchar, bigint)
Converts a string into a number based on BASE encoding.
to_base(x, radix)
Converts a number into a string based on BASE encoding.
truncate(x)
Returns x rounded to an integer by dropping digits after the decimal point.
acos(x)
Returns the arc cosine of x.
asin(x)
Returns the arc sine of x.
atan(x)
Returns the arc tangent of x.
atan2(y,x)
Returns the arc tangent of the result of dividing y by x.
cos(x)
Returns the cosine of x.
sin(x)
Returns the sine of x.
cosh(x)
Returns the hyperbolic cosine of x.
tan(x)
Returns the tangent of x.
tanh(x)
Returns the hyperbolic tangent of x.
infinity()
Returns the constant representing positive infinity.
is_nan(x)
Determines if the target value is Not a Number (NaN).
nan()
Returns a "Not a Number" (NaN) value.
mod(x, y)
Returns the remainder when x is divided by y.
sign(x)
Returns the sign of x represented by 1, 0, or -1.
width_bucket(x, bound1, bound2, n)
Returns the bucket number of x in an equi-width histogram, with n buckets within bounds of bound1 and bound2.
For example, * | select timeCost,width_bucket(timeCost,10,1000,5)
width_bucket(x, bins)
Returns the bin number of x with specific bins specified by the array bins.
For example, * | select timeCost,width_bucket(timeCost,array[10,100,1000])

Examples

To compare the PV values of today and yesterday and express the result as a percentage, the query and analysis statement is as follows:
* | SELECT diff [1] AS today, round((diff [3] -1.0) * 100, 2) AS growth FROM (SELECT compare(pv, 86400) as diff FROM (SELECT COUNT(*) as pv FROM log))

Was this page helpful?
You can also Contact Sales or Submit a Ticket for help.
Yes
No

Feedback

Contact Us

Contact our sales team or business advisors to help your business.

Contact Us
Technical Support

Open a ticket if you're looking for further assistance. Our Ticket is 7x24 avaliable.

Submit a Ticket
7x24 Phone Support
Hong Kong, China
+852 800 906 020 (Toll Free)
United States
+1 844 606 0804 (Toll Free)
United Kingdom
+44 808 196 4551 (Toll Free)
Canada
+1 888 605 7930 (Toll Free)
Australia
+61 1300 986 386 (Toll Free)
EdgeOne hotline
+852 300 80699
More local hotlines coming soon