title: Find if Record already exists in HIVE Table before inserting into it
body: <p>I have a HIVE Partitioned Table and before inserting records into it I need to find if the records already exists.</p>
  
  <p>Example.</p>
  
  <pre><code>Insert into table employee partition (day, location) select distinct name, number,
  date,aud_date, day, location from tableB.
  </code></pre>
  
  <p>If the records I am trying to Insert from tableB already exists in employee table it should bypass or write it into another table. The columns that i need to check if already exists in employee table are name, number, date, day, location. I don't want to check aud_date since it will be different.</p>