Support Questions
Find answers, ask questions, and share your expertise
Announcements
Alert: Welcome to the Unified Cloudera Community. Former HCC members be sure to read and learn how to activate your account here.

Sqoop How to import all tables into specific scheme?

Sqoop How to import all tables into specific scheme?

New Contributor

Hi, I want to import all tables from a Oracle DB, I can import table by table in to schema that I want but I not get to spend all tables in the schema that want.

 

I use

 

--connect jdbc:oracle:thin:@host:port:dbName\

--username Username -P \
--hive-import \

--hive-table mySchemaIntoHive

 

I do not want to go through default scheme

 

some suggestions?