After the required directories are created and permissions set, and the required configuration and JAR files are copied to the proper locations, you are ready to create the Sqoop>Hive>Sqoop ETL workflow in the Workflow Manager Ambari View.

See the following content to create and submit the ETL workflow:

Access the Workflow Manager View

Create the Sqoop Action to Extract Data

Create the Hive Action to Transform the Data

Create the Sqoop Action to Load the Data

Submit and Execute the Workflow Job