google-bigquery - 字段不是叶字段

Question

我收到以下查询的错误“Field signupdate is not a leaf field”

SELECT COUNT(*) AS cnt
FROM [adknowledge_data.ADKBatch_Combined_c]
WHERE ABS(HASH(MD5email) % 3 ) = 0
GROUP EACH BY MD5email, signupdate
HAVING cnt > 1

对于下表架构:

MD5email: string

IP: string

signupdate: timestamp

Answer 1

这不是一个很好的错误消息，但至少有一个解决潜在问题的简单方法:在 SELECT 表达式中包含“signupdate”。

参见:

SELECT COUNT(*) c
FROM [fh-bigquery:bigdataspain.aggr_transactions_to] 
GROUP BY time

Error: Field time [...] is not a leaf field.

对比:

SELECT COUNT(*) c, time
FROM [fh-bigquery:bigdataspain.aggr_transactions_to] 
GROUP BY time

(works!)