sec

Calcule la sécante de la colonne d’entrée. Prend en charge Spark Connect.

Pour obtenir plus de détails sur la fonction SQL de Databricks correspondante, consultez sec.

Syntaxe

from pyspark.databricks.sql import functions as dbf

dbf.sec(col=<col>)

Paramètres

Paramètre	Type	Descriptif
col	pyspark.sql.Column or column name	Angle en radians

Retours

pyspark.sql.Column: secant de l’angle.

Examples

from pyspark.databricks.sql import functions as dbf
spark.sql(
    "SELECT * FROM VALUES (PI() / 4), (PI() / 16) AS TAB(value)"
).select("*", dbf.sec("value")).show()

+-------------------+------------------+
|              value|        SEC(value)|
+-------------------+------------------+
| 0.7853981633974...| 1.414213562373...|
|0.19634954084936...|1.0195911582083...|
+-------------------+------------------+

from pyspark.databricks.sql import functions as dbf
spark.sql(
    "SELECT * FROM VALUES (FLOAT('NAN')), (NULL) AS TAB(value)"
).select("*", dbf.sec("value")).show()

+-----+----------+
|value|SEC(value)|
+-----+----------+
|  NaN|       NaN|
| NULL|      NULL|
+-----+----------+