SparkSql常用操作(updating)

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()