-- 抽查两个域下同名维度的取值集合是否一致
SELECT count(1) FROM (
  SELECT DISTINCT category_name FROM dws_a.dim_product
  EXCEPT
  SELECT DISTINCT category_name FROM dws_b.dim_product
) t;