Shankar, Currently there's no specific connector for Oracle. You should be able to use the generic RDBMS connector to talk to Oracle and transfer data to HDFS. After transferring data to HDFS, you can load data into Hive via a "create table" script. Check out https://issues.apache.org/jira/browse/SQOOP-1579?focusedCommentId=14292510#comment-14292510 for a small example of such a workflow. This is a legitimate bug, so be aware that the pathway is being worked on and should be in better condition for 1.99.5 release.
-Abe On Mon, Jan 26, 2015 at 3:06 PM, SHANKAR REDDY <[email protected]> wrote: > Team, > I am looking for if there any document to setup oracle > connector(especially connector format) to bring the data from Oracle to > Hive as I am doing trail run on 300 millions records. > > Kind Regards, > Sankara Telukutla > +1 510 936 0999 >
