title: Load table from Oracle to Hive, date and timestamp convert to string
body: <p>I have noticed this in the Sqoop manual:</p>
  <blockquote>
  <p>24.5. Schema Definition in Hive</p>
  <p>Hive users will note that there is not a one-to-one mapping between SQL types and Hive types. In general, SQL types that do not have a direct mapping (for example, DATE, TIME, and TIMESTAMP) will be coerced to STRING in Hive. The NUMERIC and DECIMAL SQL types will be coerced to DOUBLE. In these cases, Sqoop will emit a warning in its log messages informing you of the loss of precision.</p>
  </blockquote>
  <p>And I know Sqoop can specify the column - type mapping using</p>
  <ul>
  <li><code>--map-column-java</code></li>
  <li><code>--map-column-hive</code></li>
  </ul>
  <p>But my case is I need a general type to type mapping, from RDBMS type to HIVE type mapping which require date or datetime convert to a date or timestamp.</p>
  <p>Is there a solution exist?</p>