The margin is not a sheet margin
I am getting the error "The signupdate field is not a sheet field" for the following request
SELECT COUNT(*) AS cnt
FROM [adknowledge_data.ADKBatch_Combined_c]
WHERE ABS(HASH(MD5email) % 3 ) = 0
GROUP EACH BY MD5email, signupdate
HAVING cnt > 1
For the following table schema:
MD5email: string
IP: string
signupdate: timestamp
+3
source to share
1 answer
It's not a nice error message, but at least there is an easy solution to the underlying problem: Include 'signupdate' in the SELECT statement.
Cm:
SELECT COUNT(*) c
FROM [fh-bigquery:bigdataspain.aggr_transactions_to]
GROUP BY time
Error: Field time [...] is not a leaf field.
Vs:
SELECT COUNT(*) c, time
FROM [fh-bigquery:bigdataspain.aggr_transactions_to]
GROUP BY time
(works!)
+5
source to share