1 Reply Latest reply: Jul 23, 2013 2:58 PM by Mannamal-Oracle RSS

    OLH - Partition Value from Hive


      When using OLH to load data from a partitioned Hive table, the partition column is not visible to OLH for loading into the target table. Is this a bug, a known issue or a restriction ?


      e.g : When loading this Hive table into ORACLE,


      CREATE TABLE emp (

      emp_id INT,

      fname STRING,

      lname STRING,


      PARTITIONED BY (hire_year INT);


      the column hire_year is not visible to OLH though it shows up in Hive queries and describe.