Математические функции

SELECT acos(0.5);

1.0471975511965979

SELECT acosh(1)

0

SELECT asin(1.0) = pi() / 2, sin(asin(1)), asin(sin(1))

1 1 1

SELECT toTypeName(asin(1.0::Float32))

Float64

SELECT asin(1.1), asin(-2), asin(inf), asin(nan)

nan nan nan nan

SELECT asinh(0)

0

SELECT atan(1);

0.7853981633974483

SELECT atan2(1, 1)

0.7853981633974483

SELECT atanh(0)

0

SELECT cbrt(8);

2

SELECT cos(0);

1

SELECT cosh(0)

1

SELECT degrees(3.141592653589793)

180

SELECT e();

2.718281828459045

SELECT erf(3 / sqrt(2))

┌─erf(divide(3, sqrt(2)))─┐
│      0.9973002039367398 │
└─────────────────────────┘

SELECT erfc(0);

1

SELECT round(exp(-1), 4)

┌─round(exp(-1), 4)─┐
│            0.3679 │
└───────────────────┘

SELECT exp10(2);

100

SELECT exp2(3);

8

factorial(10)

3628800

SELECT hypot(1, 1)

1.4142135623730951

SELECT intExp10(2);

100

SELECT intExp2(3);

8

SELECT isPrime(17)

1

SELECT isPrime(18)

0

SELECT isPrime(18446744073709551557)

1

SELECT isPrime(18446744073709551615)

0

SELECT isProbablePrime(17)

1

SELECT isProbablePrime(18)

0

SELECT isProbablePrime(18446744073709551557)

1

SELECT isProbablePrime(toUInt128('170141183460469231731687303715884105727'))

1

SELECT isProbablePrime(toUInt256('57896044618658097711785492504343953926634992332820282019728792003956564819949'))

1

SELECT isProbablePrime(toUInt256('57896044618658097711785492504343953926634992332820282019728792003956564819949'), 5)

1

SELECT lgamma(5);

3.1780538303479458

SELECT log(10);

2.302585092994046

SELECT log10(100);

2

SELECT log1p(0)

0

SELECT log2(8);

3

SELECT pi();

3.141592653589793

SELECT pow(2, 3);

8

SELECT proportionsZTest(10, 11, 100, 101, 0.95, 'unpooled');

┌─proportionsZTest(10, 11, 100, 101, 0.95, 'unpooled')───────────────────────────────┐
│ (-0.20656724435948853,0.8363478437079654,-0.09345975390115283,0.07563797172293502) │
└────────────────────────────────────────────────────────────────────────────────────┘

SELECT radians(180)

3.141592653589793

SELECT sigmoid(0)

0.5

SELECT sign(0)

0

SELECT sign(1)

1

SELECT sign(-1)

-1

SELECT sin(1.23)

0.9424888019316975

SELECT sinh(0)

0

SELECT sqrt(16);

4

SELECT tan(0);

0

SELECT tanh(0)

0

SELECT tgamma(5);

24

widthBucket(10.15, -8.6, 23, 18)

11