isnotnull

Returns true if col is not null, or false otherwise.

For the corresponding Databricks SQL function, see isnotnull function.

Syntax

Python

from pyspark.databricks.sql import functions as dbf

dbf.isnotnull(col=<col>)

Parameters

Parameter	Type	Description
col	pyspark.sql.Column or str	The column to check.

Examples

Python

from pyspark.databricks.sql import functions as dbf
df = spark.createDataFrame([(None,), (1,)], ["e"])
df.select('*', dbf.isnotnull(df.e)).show()

Output

+----+---------------+
|   e|(e IS NOT NULL)|
+----+---------------+
|NULL|          false|
|   1|           true|
+----+---------------+