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

Sqoop import


Sqoop import


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


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:

The documentation below shows how to do incremental hive updates:

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

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