question Find a word or a group of words from a column in Hortonworks and creating it as a separate column in Support Questions

question Find a word or a group of words from a column in Hortonworks and creating it as a separate column in Support Questions https://community.cloudera.com/t5/Support-Questions/Find-a-word-or-a-group-of-words-from-a-column-in-Hortonworks/m-p/214974#M176886 Hi,I am trying to create a view in Hortonworks that I have in postgres greenplum where I am trying to find a word/words that exists in a column that has lot of words. If the word exists, the new column should show the word and if there are multiple words, the multiple words should be reflected with a space in between. Below is a running code in postgres Greenplum. Can anyone help me with the code in Hive?CREATE OR REPLACE VIEW XYZ_V AS( Select col1, col2, col3, col4,trim(both ' ' from case when substring( lower(col4) from 'abcd' ) is null then '' else substring( lower(col4) from 'abcd') end ||' '|| case when substring( lower(col4) from 'pqrs' ) is null then '' else substring( lower(col4) from 'pqrs') end ||' '|| case when substring( lower(col4) from 'mnop' ) is null then '' else substring( lower(col4) from 'mnop') end) as col5 FROM XYZ);Thanks a lot in advanceRegards Mon, 04 Jun 2018 21:04:33 GMT souveekray 2018-06-04T21:04:33Z