This discussion is archived
1 Reply Latest reply: Jul 23, 2013 12:58 PM by mannamal RSS

OLH - Partition Value from Hive

c0c54817-dc36-4946-9ca4-dd952090f789 Newbie
Currently Being Moderated

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

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points