Student Reviews
( 5 Of 5 )
1 review
Video of 13.2. Oozie Running Sqoop Action Using Oozie From Hue in Apache Hadoop course by CloudxLab Official channel, video No. 70 free certified online
Let’s run an Oozie job using Hue. Hue provides a really nice UI for defining workflows. We will run Sqoop import where we will take data from MySQL widgets table in sqoopex database and push to HDFS.
Login to Hue. Click on “Workflows”, and then “Editors". It will open a dashboard with our previous workflows. Click on “Create”. Select action as “sqoop1” and drop it to the editor. Type in command displayed on the screen. ip-172-31-13-154 is the host where MySQL server is running. We can find MySQL host, username and password from “MySQL Credentials” section under “My Lab”. We will be storing the data in widgets_import directory in HDFS under our home directory.
Click on "Add"
Now specify MySQL connector JAR which is located at /user/oozie/share/lib/sqoop. Click on “Files” and add the MySQL connector JAR
Let's name our workflow as “Sqoop import”. Press Enter. Click on “save” and then click on “Submit”. Click on “Submit” when the confirmation dialog popups.
Our job has started running now. We'll Wait for some time to get it executed. To see the data let’s go to the widgets_import directory in HDFS. We can see multiple files inside widgets_import containing data from widgets table.
This Big Data Tutorial will help you learn HDFS, ZooKeeper, Hive, HBase, NoSQL, Oozie, Flume, Sqoop, Spark, Spark RDD, Spark Streaming, Kafka, SparkR, SparkSQL, MLlib, and GraphX from scratch. Everything in this course is explained with the relevant example thus you will actually know how to implement the topics that you will learn in this course.
Let us know in the comments below if you find it helpful.
In order to claim the certificate from E&ICT Academy, IIT Roorkee, visit https://bit.ly/cxlyoutube
________
Website https://www.cloudxlab.com
Facebook https://www.facebook.com/cloudxlab
Instagram https://www.instagram.com/cloudxlab
Twitter http://www.twitter.com/cloudxlab