1) purpose of sqoop?

ans : To import and export data from rdbms to hdfs and vice versa.

2) sqoop job?
ans : Sqoop job creates and saves the import and export commands. It specifies parameters to identify and recall the saved job. This re-calling or re-executing is used in the incremental import, which can import the updated rows from RDBMS table to HDFS.

3) command to execute a sqoop job?
ans : sqoop job –exec myjob

4) codegen in sqoop?
ans : From the viewpoint of object-oriented application, every database table has one DAO class that contains ‘getter’ and ‘setter’ methods to initialize objects. This tool (-codegen) generates the DAO class automatically.It generates DAO class in Java, based on the Table Schema structure. The Java definition is instantiated as a part of the import process. The main usage of this tool is to check if Java lost the Java code. If so, it will create a new version of Java with the default delimiter between fields.

5) sqoop workflow in oozie?
ans : <workflow-app name=”sample-wf” xmlns=”uri:oozie:workflow:0.1″>

<action name=”myfirsthivejob”>
<sqoop xmlns=”uri:oozie:sqoop-action:0.2″>
<delete path=”${jobOutput}”/>
<command>import –connect jdbc:hsqldb:file:db.hsqldb –table TT –target-dir hdfs://localhost:8020/user/tucu/foo -m 1</command>
<ok to=”myotherjob”/>
<error to=”errorcleanup”/>



<workflow-app name=”sample-wf” xmlns=”uri:oozie:workflow:0.1″>

<action name=”myfirsthivejob”>
<sqoop xmlns=”uri:oozie:sqoop-action:0.2″>
<ok to=”myotherjob”/>
<error to=”errorcleanup”/>


6)import subset of tableDate?
ans : sqoop import \
–connect jdbc:mysql://localhost/userdb \
–username root \
–table emp_add \
–m 1 \
–where “city =’sec-bad’” \
–target-dir /wherequery

7) import incremental import?
ans : sqoop import \
–connect jdbc:mysql://localhost/userdb \
–username root \
–table emp \
–m 1 \
–incremental append \
–check-column id \
-last value 1205

to our newsletter

Drop Us A Query

Trending Courses
  • Pega testing training
    PEGA Testing Training
  • Today application testing is the deciding factor to launch the application into the market. And people do not launch the application unless it goes true.

  • blockchain course
    Blockchain Online Course
  • Today many people were enthusiastic, to know the exact details of things happening around him. This can get the proper knowledge on Blockchain.

  • ethical hacking course
    Ethical Hacking Certification Course
  • Zeal to learn ethical hacking is common among college students and IT professionals. Because everybody wants to secure their system from cyber attacks.

  • python training
    Python Online Training
  • Python is a dynamic interrupted language which is used in wide varieties of applications. It is very interactive object oriented and high-level programming language.

  • Tableau Training
    Tableau Training
  • Tableau is a Software company that caters interactive data visualization products that provide Business Intelligence services. The company’s Head Quarters is in Seattle, USA.

  • what is pega
    PEGA Online Training
  • Pega Systems Inc. is a Cambridge, Massachusetts based Software Company. It is known for developing software for Customer Relationship Management (CRM) and Business process Management (BPM).


100% Secure Payments. All major credit & debit cards accepted.