bit_and

Mengembalikan bitwise AND dari semua nilai input non-null, atau null jika tidak ada.

Syntax

from pyspark.sql import functions as sf

sf.bit_and(col)

Parameter-parameternya

Pengaturan	Tipe	Description
col	pyspark.sql.Column atau nama kolom	Kolom target untuk dihitung.

Pengembalian Barang

pyspark.sql.Column: bitwise AND dari semua nilai input non-null, atau null jika tidak ada.

Examples

Contoh 1: Bitwise AND dengan semua nilai non-null

from pyspark.sql import functions as sf
df = spark.createDataFrame([[1],[1],[2]], ["c"])
df.select(sf.bit_and("c")).show()

+----------+
|bit_and(c)|
+----------+
|         0|
+----------+

Contoh 2: Bitwise AND dengan nilai null

from pyspark.sql import functions as sf
df = spark.createDataFrame([[1],[None],[2]], ["c"])
df.select(sf.bit_and("c")).show()

+----------+
|bit_and(c)|
+----------+
|         0|
+----------+

Contoh 3: Bitwise AND dengan semua nilai null

from pyspark.sql import functions as sf
from pyspark.sql.types import IntegerType, StructType, StructField
schema = StructType([StructField("c", IntegerType(), True)])
df = spark.createDataFrame([[None],[None],[None]], schema=schema)
df.select(sf.bit_and("c")).show()

+----------+
|bit_and(c)|
+----------+
|      NULL|
+----------+

Contoh 4: Bitwise AND dengan nilai input tunggal

from pyspark.sql import functions as sf
df = spark.createDataFrame([[5]], ["c"])
df.select(sf.bit_and("c")).show()

+----------+
|bit_and(c)|
+----------+
|         5|
+----------+