Spark-Shell Scala 数据集仅显示查询中的几列

Question

我正在尝试在 Scala 中仅显示几列，例如名称、地址和邮政编码，

到目前为止我已经有了...

scala> pe06DS.filter(pe06data => pe06data.state == "OH").show()
+--------------+--------+----------+-----+-----+
|       address|    city|      name|state|  zip|
+--------------+--------+----------+-----+-----+
|84 Arcadia Dr.|Westlake|John Smith|   OH|44145|
+--------------+--------+----------+-----+-----+


scala> pe06DS.show()
+--------------------+--------+----------+-----+-----+
|             address|    city|      name|state|  zip|
+--------------------+--------+----------+-----+-----+
|      84 Arcadia Dr.|Westlake|John Smith|   OH|44145|
|8691 Rockledge St...|Westlake|  Jane Doe|   NY|12302|
|     6 Tallwood Road|Westlake|Tom Tucker|   OR|97402|
|     37 Chestnut Rd.|Westlake| Jack Hill|   MI|48150|
+--------------------+--------+----------+-----+-----+


scala> pe06DS.filter(pe06data => pe06data.state == "OH").show()
+--------------+--------+----------+-----+-----+
|       address|    city|      name|state|  zip|
+--------------+--------+----------+-----+-----+
|84 Arcadia Dr.|Westlake|John Smith|   OH|44145|
+--------------+--------+----------+-----+-----+

但不能只使用过滤器显示 3 列

Answer 1

我得到了它。我只需要想办法。

cala> pe06DS.filter(pe06data => pe06data.state == "OH").select(col("name").alias("Name"),col("address").alias("Address"),col("zip").alias("Zip")).show()
+----------+--------------+-----+
|      Name|       Address|  Zip|
+----------+--------------+-----+
|John Smith|84 Arcadia Dr.|44145|
+----------+--------------+-----+