Error: No matching signature for operator = for argument types: STRUCT, STRING. Supported signatures: ANY = ANY
Sample query:
#standardsql\nSELECT field1,field2\nFROM `censys-io.domain_public.current`\nWHERE filed3 = "some_string_here";\n
\n\nError 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\nBy, Inspecting the error, It tells us that the line
\n\nWHERE filed3 = "some_string_here";\n
\n\nHas 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 onEnjoy 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
Post Comment