question Re: Demo worked loaded data and was able to view via impala, Thanks Sean ! now.. in Archives of Support Questions (Read Only)

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

Dev4Hadoop — Fri, 16 Sep 2022 09:33:26 GMT

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

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

Sean — Wed, 08 Jul 2015 15:05:55 GMT

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.

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

Dev4Hadoop — Wed, 15 Jul 2015 10:45:51 GMT

Thanks Sean, you the best!!