Help Center/ Data Lake Insight/ SQL Syntax Reference (To Be Offline)/ Spark SQL Syntax Reference (Unavailable Soon)/ Built-in Functions/ Mathematical Functions/ asin
Updated on 2023-10-25 GMT+08:00
View PDF

asin

This function is used to return the arc sine value of a given angle a.

Syntax

asin(DOUBLE a)

Parameters

Table 1 Parameter

Parameter

Mandatory

Type

Description

a

Yes

DOUBLE, BIGINT, DECIMAL, or STRING

The value range is [-1,1]. The value can be a float, integer, or string.

If the value is not of the DOUBLE type, the system will implicitly convert it to the DOUBLE type for calculation.

Return Values

The return value is of the DOUBLE type. The value ranges from -π/2 to π/2.

  • If the value of a is not within the range [-1,1], NaN is returned.
  • If the value of a is NULL, NULL is returned.

Example Code

The value 1.5707963267948966 is returned.

select asin(1);

The value 0.6435011087932844 is returned.

select asin(0.6);

The value NULL is returned.

select asin(null);

The value NAN is returned.

select asin(10);
Parent topic: Mathematical Functions