title: Is there a Hive equivalent of SQL “ LIKE '_Z_%' ESCAPE '%' ”
body: <p>While Hive supports LIKE queries: ex.</p>
  
  <pre><code>select last_name from employee WHERE  last_name LIKE '_Z_%';
  </code></pre>
  
  <p>Hive Does not support  LIKE with ESCAPE queries: ex.</p>
  
  <pre><code>select last_name from employee WHERE  last_name LIKE '_Z_%' ESCAPE '%';
  </code></pre>
  
  <p>Does anyone know an equivalent solution that Hive does support?</p>