BigQuery 中 ARRAY_CONCAT_AGG 的 DISTINCT 结果

使用 BigQuery ARRAY_CONCAT_AGG 函数创建独特数组合并

sql
SELECT
  user_id,
  ARRAY_CONCAT_AGG(DISTINCT viewed_products) AS unique_products
FROM
  user_browsing_history
GROUP BY
  user_id;

sql
-- 创建模拟数据表
CREATE TABLE user_browsing_history AS
SELECT 1 AS user_id, [101, 102, 103] AS viewed_products UNION ALL
SELECT 2 AS user_id, [102, 104, 105] AS viewed_products UNION ALL
SELECT 3 AS user_id, [101, 103, 105] AS viewed_products;
-- 执行数组合并查询
SELECT
  user_id,
  ARRAY_CONCAT_AGG(DISTINCT viewed_products) AS unique_products
FROM
  user_browsing_history
GROUP BY
  user_id;