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

    OLH - Partition Value from Hive

    c0c54817-dc36-4946-9ca4-dd952090f789

      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.

       

      Regards,

      Ashok