https://community.cloudera.com/t5/Support-Questions/Find-a-word-or-a-group-of-words-from-a-column-in-Hortonworks/m-p/214979#M176891 <P>Hey <A rel="user" href="https://community.cloudera.com/users/83246/souveekray.html" nodeid="83246">@Souveek Ray</A><BR />Maybe this code can help you (it's just a scratch)</P><PRE>select concat_ws(' ',case when regexp_extract('abcd pqrs xyzsd mnop', '(abcd)', 0) is null then '' else 'abcd' end, case when regexp_extract('abcd pqrs xyzsd mnop', '(mnop)', 0) is null then '' else 'mnop' end, case when regexp_extract('abcd pqrs xyzsd mnop', '(pqrs)', 0) is null then '' else 'pqrs' end) </PRE> Thu, 07 Jun 2018 00:22:48 GMT vmurakami 2018-06-07T00:22:48Z