title: how to escape % (percent sign) in Hive QL?
body: <p>I need my filter to retrieve rows which contain values <code>CPU usage %</code> and also <code>% usage</code> as follows:</p>
  
  <p>where m.CounterName like <code>%CPU usage \%</code> or <code>m.CounterName</code> like <code>\%usage%</code>.</p>
  
  <p>The backslash works for <code>CPU usage %</code> but not <code>% usage</code> </p>
  
  <p>How do I escape <code>%</code> sign ...when the <code>%</code> is at beginning of the string I'm looking for?</p>