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

Sample query:

\n\n
#standardsql\nSELECT field1,field2\nFROM `censys-io.domain_public.current`\nWHERE filed3 = "some_string_here";\n
\n\n

Error Message:

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

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

\n\n
WHERE filed3 = "some_string_here";\n
\n\n

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

Enjoy great content like this and a lot more !

Signup for a free account to write a post / comment / upvote posts. Its simple and takes less than 5 seconds