Hive – array in WHERE Close

by token|Published January 22, 2020-Updated January 22, 2020

 select * 
 from mytable 
 where array_contains(likes_and_preferences,'item') = TRUE