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

Highlighted

Sqoop import

Explorer

how to do incremental load from mysql to hive using sqoop with automation for every one hour.

Please try to help me today i need to submit my task

Thanks in advance

1 REPLY 1

Re: Sqoop import

You can use an Oozie flow to schedule the sqoop import. This article discusses how to use Oozie to schedule a workflow:

https://docs.hortonworks.com/HDPDocuments/HDP2/HDP-2.4.0/bk_dataintegration/content/ch_using-oozie.h...

The documentation below shows how to do incremental hive updates:

https://docs.hortonworks.com/HDPDocuments/HDP2/HDP-2.4.0/bk_dataintegration/content/incrementally-up...

Another approach is to use NiFi with Hive Streaming. This approach uses Nifi rather than sqoop:

https://community.hortonworks.com/questions/58103/best-approach-for-incremental-sqoop-of-data-from-r...

Don't have an account?
Coming from Hortonworks? Activate your account here