title: How to implement Oracle's "func(...) keep (dense_rank ...)" In Hive
body: <p>I have a table abcd in Oracle DB</p>
  
  <pre><code>  +-------------+----------+
    | abcd.speed  | abcd.ab  |
    +-------------+----------+
    | 4.0         | 2        |
    | 4.0         | 2        |
    | 7.0         | 2        |
    | 7.0         | 2        |
    | 8.0         | 1        |
    +-------------+----------+
  </code></pre>
  
  <p>And I'm using a query like this:</p>
  
  <pre><code>select min(speed) keep (dense_rank last order by abcd.ab NULLS FIRST) MOD from abcd;
  </code></pre>
  
  <p>I'm trying to convert the code to Hive, but it looks like <code>keep</code> is not available in Hive.<br>
  Could you suggest an equivalent statement?</p>