These are the feature list available i believe. You can create a custom udf for the contains. A similar example is explained on this StackOverflow post 

Thanks
Best Regards

On Sun, Nov 9, 2014 at 7:27 PM, Srinivas Chamarthi <srinivas.chamarthi@gmail.com> wrote:
can anyone point me to a documentation on supported sql functions ? I am trying to do a contians operation on sql array type. But I don't know how to type the  sql. 

// like hive function array_contains 
select * from business where array_contains(type, "insurance") 



appreciate any help.