title: Sqoop to dynamically create hive partitioned table from oracle and import data
body: <p>I have a table in oracle (table name is TRCUS) with customer's details, partitioned based on year &amp; month.
  Partitions name in Oracle:
  PERIOD_JAN_13,
  PERIOD_FEB_13,
  PERIOD_JAN_14,
  PERIOD_FEB_14 etc</p>
  
  <p>Now I want to import this table's data into HIVE using SQOOP directly.</p>
  
  <p>Sqoop job should create a hive table, dynamically create partitions based on the oracle table partition and then import data into hive; into the respective partitions.</p>
  
  <p>How can this be achievable using SQOOP ? </p>