title: How to transfer data & metadata from Hive to RDBMS
body: <p>There are more than 300 tables in my hive environment.
  I want to export all the tables from Hive to Oracle/MySql including metadata.</p>
  
  <p>My Oracle database doesn't have any tables corresponding to these Hive tables.</p>
  
  <p>Sqoop import from Oracle to Hive creates tables in Hive if the table doesn't exists.<br>But Sqoop export from Hive to Oracle doesn't create table if not exists and fails with an exception.</p>
  
  <p>Is there any option in Sqoop to export metadata also? or
  <br>Is there any other Hadoop tool through which I can achieve this?</p>
  
  <p>Thanks in advance</p>