title: how to check the last two characters are digits in hive?
body: <p>in sql I use</p>
  
  <pre><code>regexp_instr(substr(trim(col),1,2),'^([0-9]){2}$') = 1
  </code></pre>
  
  <p>but I not sure how can I check this in hive, I tried <code>regexp_extract</code> instead <code>regexp_instr</code> but I just have the last digit then.</p>