title: Case Statement with duplicate values, Hadoop
body: <p>I am working with email addresses who have signed up once with zero value and then again with certain amount attached. I can do a distinct email query with case statement but what I am struggling with is, if an email has zero value in gross amount, then search for that email in rest of the table with >0 value and give that email address as distinct. </p>
  
  <p>Any suggestions?</p>
  
  <p>Sample Data:
  Table with two field - Email and Gross Amount</p>
  
  <pre><code>Email: abc@gmail.com | Gross Amt: $0    
  Email: abc@gmail.com | Gross Amt: $50    
  Email: xyz@gmail.com | Gross Amt: $0
  </code></pre>
  
  <p>Output needed: </p>
  
  <pre><code>Email with 0 value: xyz@gmail.com    
  Email with &gt;0 value: abc@gmail.com
  </code></pre>