title: Remove duplicate rows by counts in Hive SQL?
body: <p>Some of the articles did help on the stack, however, could not find to delete rows by counts in Hive. </p>
  
  <p>There are 2 row_counts for Apple. How do I select only 1 row count for Apple?</p>
  
  <p>--What data looks like...Total 14 records</p>
  
  <pre><code>customerID     date product_type            
  1234abc       20140105  Orange      
  1234abc       20140105  Apple       
  1234abc       20140205  Orange      
  1234abc       20140205  Apple       
  1234abc       20140205  Apple       
  1234abc       20140305  Orange      
  1234abc       20140305  Apple       
  1234abc       20140305  Apple       
  1234abc       20140405  Orange      
  1234abc       20140405  Apple       
  1234abc       20140405  Apple       
  1234abc       20140505  Orange      
  1234abc       20140505  Apple       
  1234abc       20140505  Apple       
  </code></pre>
  
  <p>--Final Output. Total 10 records</p>
  
  <pre><code>customerID     date product_type    
  1234abc       20140105  Orange      
  1234abc       20140105  Apple       
  1234abc       20140205  Orange      
  1234abc       20140205  Apple       
  1234abc       20140305  Orange      
  1234abc       20140305  Apple       
  1234abc       20140405  Orange      
  1234abc       20140405  Apple       
  1234abc       20140505  Orange      
  1234abc       20140505  Apple       
  </code></pre>