title: RDMS data archiving in Hadoop
body: <p>We are exploring options to archive data in warehouse or RDMS to Hadoop. </p>
  
  <p>As matter of fact I have to use sqoop to load data in to HDFS and probably have to compress it. Then delete the rows which are to be archived. </p>
  
  <p>Trouble is when I have foreign key relation between two tables. I need to maintain data consistency between tables. Please help me with approach.</p>