Compartir a través de


asinh

Calcula el seno hiperbólico inverso de la columna de entrada. Soporta Spark Connect.

Para obtener la función SQL de Databricks correspondiente, consulte asinh function.

Syntax

from pyspark.databricks.sql import functions as dbf

dbf.asinh(col=<col>)

Parámetros

Parámetro Tipo Description
col pyspark.sql.Column or column name columna de destino en la que se va a calcular.

Devoluciones

pyspark.sql.Column: la columna para los resultados calculados.

Examples

from pyspark.databricks.sql import functions as dbf
df = spark.createDataFrame([(-0.5,), (0.0,), (0.5,)], ["value"])
df.select("*", dbf.asinh(df.value)).show()
+-----+--------------------+
|value|        ASINH(value)|
+-----+--------------------+
| -0.5|-0.48121182505960...|
|  0.0|                 0.0|
|  0.5| 0.48121182505960...|
+-----+--------------------+

from pyspark.databricks.sql import functions as dbf
spark.sql(
    "SELECT * FROM VALUES (FLOAT('NAN')), (NULL) AS TAB(value)"
).select("*", dbf.asinh("value")).show()
+-----+------------+
|value|ASINH(value)|
+-----+------------+
|  NaN|         NaN|
| NULL|        NULL|
+-----+------------+