Import data from oracle database table to Hive external table using Sqoop command

preview_player
Показать описание
This tutorial shows how to import the structured data from oracle database table to Hive external table using Sqoop command.
Рекомендации по теме
Комментарии
Автор

Thanks to sharing knowledge. It will be good if you can post scoop command with where clause with dynamic value from existing hive table value

pankajmhatre
Автор

I have a questions please, do we need any ODBC (or JDBC) driver to make connection between Cloudera and Oracle ?

elmehdiouafiq
Автор

I have tried this and there is error saying "Must specify destination with --target-dir". Its asking for target directory even if the table is external. PLease help!

bhanudaybirla
Автор

here you are creating an extrenal table in hive data warehouse, external table should be in non hive area, or somwhere in hdfs right ?

ssquare
Автор

Any clue to enable SSL over TCPS protocol on Oracle.?

vinishg
join shbcf.ru