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 import issue

sqoop import issue

Explorer

Hi All,

I have imported all tables from SQl server to hive without any error.

now i have added few more tables into  SQL server how can i import only those tables which are newly added to sql server, also i want to import tables  in which some modification or updation done, which are already in hive warehouse.

1 REPLY 1
Highlighted

Re: sqoop import issue

Guru
@hiveexport,

To import only specific tables, you can specify "--table" option, for modifications or updates, you need to use incremental import. Details can be found in the Sqoop's official documentation:

http://sqoop.apache.org/docs/1.4.7/SqoopUserGuide.html

Cheers
Eric