title: Extract rows from a table with regular expression hive sql
body: <p><a href="https://i.stack.imgur.com/4yNvf.jpg" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/4yNvf.jpg" alt="Check the table info here "></a>                                                               </p>
  
  <p>Please check the link for the result and table info. I need to query rows 
  with value '343' in Col B with a regular expression . All columns are strings . Also please be kind enough to point any good learning materials in how to write good REGEX in Hive . Thank you</p>