hive-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Tharindu Mathew <mcclou...@gmail.com>
Subject Searching for a string off a group by query
Date Mon, 16 Jul 2012 20:56:40 GMT
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/

Mime
View raw message