map_contains_key

Mengembalikan true jika peta berisi kunci.

Syntax

from pyspark.sql import functions as sf

sf.map_contains_key(col, value)

Parameter-parameternya

Pengaturan Tipe Description
col pyspark.sql.Column atau str Nama kolom atau ekspresi yang mewakili peta.
value Apa saja Nilai harfiah, atau ekspresi Kolom.

Pengembalian Barang

pyspark.sql.Column: True jika kunci ada di peta dan False sebaliknya.

Examples

Contoh 1: Kuncinya ada di peta

from pyspark.sql import functions as sf
df = spark.sql("SELECT map(1, 'a', 2, 'b') as data")
df.select(sf.map_contains_key("data", 1)).show()
+-------------------------+
|map_contains_key(data, 1)|
+-------------------------+
|                     true|
+-------------------------+

Contoh 2: Kunci tidak ada di peta

from pyspark.sql import functions as sf
df = spark.sql("SELECT map(1, 'a', 2, 'b') as data")
df.select(sf.map_contains_key("data", -1)).show()
+--------------------------+
|map_contains_key(data, -1)|
+--------------------------+
|                     false|
+--------------------------+

Contoh 3: Periksa kunci menggunakan kolom

from pyspark.sql import functions as sf
df = spark.sql("SELECT map(1, 'a', 2, 'b') as data, 1 as key")
df.select(sf.map_contains_key("data", sf.col("key"))).show()
+---------------------------+
|map_contains_key(data, key)|
+---------------------------+
|                       true|
+---------------------------+