31 August 2018 · DataFreak ·       Add to Favorites   Report

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


Read great educational content like this and a lot more !

Members get free exclusive access to content, new courses, and discounts. Signup for a free account to write a post / comment / upvote posts. Creating an account takes less than 5 seconds and you can start earning badges & points too

Copied