Hi everyone, I'd like to do $subject and was approaching it with the following query:
select activityId, count(activityId), *find_in_set("CCC", collect_set(msgBody))* from ActivityStream group by activityId; But find_in_set doesn't seem to accept arrays. Is there a way to cast this string array into a string list or a string so I can conduct a search? Maybe, there's another way to do this. Thanks in advance. -- Regards, Tharindu blog: http://mackiemathew.com/