0

I am new to Hive. I want to compare two tables and their data and get the data which are not matching. In SQL, we can do this using "MINUS", but it's not supported in Hive. So I want to know the different ways that will get my job done.

Vineet Kumar
  • 3
  • 2
  • 1
    matching two tables means a lot of thing, could you please explain what you want to example ? – Gaurang Shah Sep 24 '18 at 14:33
  • Please have a look at this answer about tables compare using full join: https://stackoverflow.com/a/51837372/2700344 – leftjoin Sep 24 '18 at 16:13
  • There are two tables-source and target. So I want those records that are extra in source table after a given condition. When the given condition is applied then those records shouldn't be in target but are still there. I want to know the various ways to find those records. – Vineet Kumar Sep 24 '18 at 16:44
  • Possible duplicate of [Hive QL Except clause](https://stackoverflow.com/questions/10889029/hive-ql-except-clause) – mazaneicha Sep 25 '18 at 11:12
  • MINUS is an Oracle extension. Corresponding ANSI SQL standard keyword is EXCEPT. – mazaneicha Sep 25 '18 at 11:13

0 Answers0