使用Google BigQuery建立直方图

使用Google BigQuery建立直方图

---

子查询的想法和“ CASE WHEN”一样有效，然后按以下方式进行分组：

SELECt SUM(field1), bucket FROM (    SELECt field1, CASE WHEN age >=  0 AND age < 10 THEN 1  WHEN age >= 10 AND age < 20 THEN 2  WHEN age >= 20 AND age < 30 THEN 3  ...  ELSE -1 END as bucket    FROM table1) GROUP BY bucket

或者，如果存储桶是规则的，则可以将它们除并转换为整数：

SELECt SUM(field1), bucket FROM (    SELECt field1, INTEGER(age / 10) as bucket FROM table1)GROUP BY bucket