grouping()显示pyspark中的行为与oracle不一致

from pyspark.sql import SparkSession
from pyspark.sql.functions import grouping

# 创建SparkSession
spark = SparkSession.builder.getOrCreate()

# 读取数据
data = [("Alice", "Math", 80),
        ("Alice", "Science", 90),
        ("Bob", "Math", 75),
        ("Bob", "Science", 85),
        ("Bob", "History", 70)]

df = spark.createDataFrame(data, ["Name", "Subject", "Score"])

# 使用grouping()函数检查Subject列是否被分组
result = df.groupby("Name").agg(grouping("Subject").alias("IsGrouped"))

result.show()

+-----+---------+
| Name|IsGrouped|
+-----+---------+
|Alice|        1|
|  Bob|        1|
+-----+---------+