1. Administration and Configuration Guide
  2. Data Management Tools (DMT) Module Configurations
  3. Oracle® Loader for Hadoop (OLH) Configuration
  4. Limitations

Limitations

  • OLH can read data from a Single Source Table (ANSI joins are not supported) and load it into a single target RDBMS table.
  • OLH 2.3.1 is built against HIVE 0.10. It works well with HIVE 0.12 too; however, the Data Type DATE (that is supported in HIVE 12) is not supported by OLH.
  • Mapping a Hive column with the Data Type STRING (even if it contains a single character) to an RDBMS column with the Data Type CHAR is not allowed. The Destination Column should be at least VARCHAR2 (1) or the Source Column Data Type should be CHAR.
  • Joins/Filters/Expressions are not supported in OLH.
  • OLH is not supported with Cloudera Connectors. As a workaround, perform Step 6.