Error: No matching signature for operator = for argument types: STRUCT, STRING. Supported signatures: ANY = ANY

Sample query:

#standardsql
SELECT field1,field2
FROM `censys-io.domain_public.current`
WHERE filed3 = "some_string_here";

Error Message:

 Error: No matching signature for operator = for argument types: STRUCT<id STRING, name STRING>, STRING. Supported signatures: ANY = ANY at [4:7]

By, Inspecting the error, It tells us that the line

WHERE filed3 = "some_string_here";

Has an incorrect comparison. You are trying to compare a STRUCT column filed3 with a STRING value. Try fixing this and rerun the query

DataFreak

posted on 31 Aug 18