title: Using QUALIFY Row_Number in hive
body: <p>I'm working with Teradata conversion to Hive (version 0.10.0).</p>
  
  <p>Teradata Query :</p>
  
  <pre><code>QUALIFY ROW_NUMBER() OVER (PARTITION BY ADJSTMNT,SRC_CMN , TYPE_CMD,IOD_TYPE_CD,ROE_PST ,ORDR_SYC,SOR_CD,PROS_ED ORDER BY ADJSTMNT )=1
  </code></pre>
  
  <p>I did my search and found UDF for Row_Sequence in hive. I also replaced Over Partition with Distribute All and sort By. But I am stuck with QUALIFY.</p>
  
  <p>Any ideas to convert the above to hive are really appreciated and will help us a lot.</p>