Hi All, I have a string String: some text with an ip 111.111.111.111 and a decimal 11.2323232 and some text here and then an int 1 and then some HTTP/1.1 with a 503 request and then another ip 222.222.222.222 and some imaginary 999.999.999.999 I want to output all the ip addresses in comma saperated. I tried the below select regexp_replace(regexp_replace(String,'[^(\\d{1,3}\\.\\d{1,3}\\.\\d{1,3}\\.\\d{1,3}\\.\\d{1,3})]',' '),'\\s+',','); +------------------------------------------------------------------------+--+ | _c0 | +------------------------------------------------------------------------+--+ | ,111.111.111.111,11.2323232,1,1.1,503,222.222.222.222,999.999.999.999 | +------------------------------------------------------------------------+--+ Expected output is : 111.111.111.111,222.222.222.222,999.999.999 Could you please help me ... View more

Hi All, I need help to get the below result. I have two tables table name: match +-----------------------------------+----------------+--+ | hint | remarks | +-----------------------------------+----------------+--+ | 1.1.1.1 | ip | | 123456789 | contact | | http://123123123123123123.some_n | url | +-----------------------------------+----------------+--+ table name : t1 +-------------------------------------------------------------------------------+-------------------+--+ | t1.text | t1.b | +-------------------------------------------------------------------------------+-------------------+--+ | This ip is found 1.1.1.1 and is matched with match | table name match | | This ip is found 1.1.1.2 and is matched with match | table name match | | This contact is found 123456789 and is matched with match | table name match | | This contact is found 123456789123456789 and is matched with match | table name match | | This url is found http://123456789123456789.some_n and is matched with match | table name match | +-------------------------------------------------------------------------------+-------------------+--+ I want to search hint column of match table in text column of t1 table and get complete text column values. so, basically I want to do a query like select t1.text from t1 join match where t1.text contains (any value in match.hint); It will be helpful if this can be done in hive or I can live with pyspark, so pyspark help is also welcome P.S: table t1 is a big table and match is a small table with limite values(say 1500). Thank you ... View more