How to convert an Array field into String to be used in 'WHERE' clause in Query Service Hi Team, I am trying to query service for a dataset 'TEST_DATASET" which has an Array field - "products"I am trying to query in Query Service -select field1, field2, field3, productsfrom TEST_DATASETwhere VARCHAR(products) like '%pencil%' Basically i am trying to check if the 'product' field, which is an Array datatype, contains the value 'pencil'. I am unable to use the array field in WHERE clause without converting to String. I have tried multiple functions - VARCHAR, ARRAY_TO_STRING, TO_STRING, INLIN but none of them are supported and throwing an error. Please suggest how do I convert an array field into string to be used in WHERE clause in Query Service.
