Hi Venkat,
I'm not sure what this will do in regards to Hive partitions - I'll test it out
when I get into the office and get back to you. But this option will make it so
there is one file for each Oracle partition - which might be of interest to you.
Match Hadoop Files to Oracle Table Partitions
-Doraoop.chunk.method={ROWID|PARTITION}
To import data from a partitioned table in such a way that the resulting HDFS
folder structure in
Hadoop will match the table's partitions, set the chunk method to PARTITION.
The alternative
(default) chunk method is ROWID.
Notes:
l For the number of Hadoop files to match the number of Oracle partitions, set
the number
of mappers to be greater than or equal to the number of partitions.
l If the table is not partitioned then value PARTITION will lead to an error.
David
From: Venkat, Ankam [mailto:[email protected]]
Sent: Wednesday, 6 August 2014 3:56 AM
To: '[email protected]'
Subject: Import Partitions from Oracle to Hive Partitions
I am trying to import partitions from Oracle table to Hive partitions.
Can somebody provide the syntax using regular JDBC connector and Oraoop
connector?
Thanks in advance.
Regards,
Venkat
