sql(
"""
|SELECT short_group_id, store_id FROM tv_client_group
|WHERE last_group_update_time IS NULL
|""".stripMargin).agg(
array_join(collect_set(functions.concat($"store_id", expr("':' AS separator"), $"short_group_id")), ",").as("storeGroupIds"),
).where("storeGroupIds <> ''").map {
case Row(storeGroupIds: String) => {
storeGroupIds
}
}.collect()
SparkSql常用操作(updating)
最新推荐文章于 2023-05-17 11:34:04 发布