'Item_id' is column in array format like ["ba1b-5fbe1547ddd5", "88f9-ac3b93334f69", "8bba-4075a47eb814"] in table1 and table2 has column Id with single value like ba1b-5fbe1547ddd5.

While join two table

select 

table1.*,

table2.*

from table1

left join table2

on array_contains(table2.id, table1.item_id)

getting below error

Error in SQL statement: AnalysisException: cannot resolve 'array_contains(table2.id, table1.item_id)' due to data type mismatch: Input to function array_contains should have been array followed by a value with same element type, but it's [string, array<string>].

@Hubert Dudek​ ​ @Werner Stinckens​ ​ @Aviral Bhardwaj​ ​ @HEMANT PATEL​  @Omkar G​ ​ @yogu (Customer)​ @Gam Nguyen​ ​ @Aman Sehgal​  @Ajay Pandey​  @Aayush Patel​  @Hau Nguyen​