title: Using hive variable in regex
body: <p>I'd like to extract texts based on some key words from Hive database.</p>
  
  <p>It works if my script looks like,</p>
  
  <pre><code>SELECT text
  FROM table
  WHERE text RLIKE '.?(aaa|bbb|ccc).?';
  </code></pre>
  
  <p>But in order to make the script more readable, I'd like to set the key words as a variable in hive. But the script fails if it looks like,</p>
  
  <pre><code>SET hivevar:KeyWords='.?(aaa|bbb|ccc).?';
  
  SELECT text
  FROM table
  WHERE text RLIKE ${hivevar:KeyWords};
  </code></pre>
  
  <p>Any idea? Thanks.</p>
  
  <p>Fu</p>