https://community.cloudera.com/t5/Support-Questions/Compare-Tables-between-Hive-and-Oracle/m-p/198133#M160184 <P>Depending on the scale and complexity of table I can think of one of three ways:</P><OL><LI>Export the data from Hive and Oracle as CSV file and diff the files</LI><LI>Use Sqoop to pull the tables from Hive to Oracle or vice versa and write a join query to get the diff</LI><LI>Programmatically use a simple JDBC client to fetch data from Oracle and Hive and compare</LI></OL> Fri, 14 Apr 2017 07:45:50 GMT deepesh1 2017-04-14T07:45:50Z