title: selecting rows that contain certain text for the column of data type dictionary in Presto
body: <p>I have a table which has multiple columns with 20 million rows. I am only interested in the rows that has a string "robot" for the column global which is of datatype dictionary in presto Db. I have tried map functions and array functions but couldn't find anything on internet. </p>
  
  <p>My row looks like the following </p>
  
  <p>Column name "global" </p>
  
  <p>Column Value</p>
  
  <pre><code>{IS_ROBOT=false, field2=value, ROBOT=false, v_DA_E=, v_DA_T=Internet, 
  v_DA_F=Explorer, v_DA_VER=11}
  </code></pre>
  
  <p>Please note that not every row contains ROBOT key regex. The goal is to get the rows that contain that regex as key</p>
  
  <p>edit
  datatype is <code>map&lt;string,string&gt;</code> </p>