Is there an equivalent to the Contains function in SAS Hadoop?

AnuragAnurag
in Hive

Is there an equivalent to the Contains function in SAS Hadoop (explicit SQL Pass through) ?
WHEN my.DESCRIPTION NOT CONTAINS "ZZZ"

I tried:
When (array_contains(my.DESCRIPTION ,'ZZZ') = FALSE)
It did not work. Any Suggestion?
Thanks in advance.

Tagged:
Share on Google+
Sign In or Register to comment.