title: Using like operator to check for pattern in hive
body: <p>I need to retrieve the columns from a hive table that must begin with uppercase letter and end with digit.
  I used this query</p>
  <pre><code>select * from tab1 where col1 like '[A-Z]%[0-9]';
  </code></pre>
  <p>But not able to retrieve the records ,getting only empty result.</p>