Demo worked loaded data and was able to view via impala, Thanks Sean ! now..

[#1]

Hi,

Is there any link or kb you can suggest to copy oracle data to hadoop not "mysql"... and lets say oracle is running on a different host,

Much appreciated all the help!!  ( I know these are stupid questions and you guys might have answered gazillion times.. )

Much appreciated!

Regards,

Dev

[#2 · Accepted solution]

So in the tutorial you used Sqoop to import data from MySQL, right? Sqoop
also supports Oracle (and a number of other data sources such as other
relational databases, mainframes, etc.) and you can also use Sqoop to
export the data back to a relational database. I'd suggest you have a look
at Sqoop's documentation to see all the various options, etc. Sqoop in CDH
is currently based on Sqoop 1.4.5 (with some other fixes / improvements
back-ported): http://sqoop.apache.org/docs/1.4.5/index.html.

There's also "Sqoop 2" which is still being developed but is available in
CDH. It uses a client-server model instead of just the CLI tool. It was
Sqoop 1 which you would've seen in the tutorial, though.

[#3]

Thanks Sean, you the best!!