Click to rate this post!
[Total: 0 Average: 0]

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″>
<job-traker>foo:8021</job-tracker>
<name-node>bar:8020</name-node>
<prepare>
<delete path=”${jobOutput}”/>
</prepare>
<configuration>
<property>
<name>mapred.compress.map.output</name>
<value>true</value>
</property>
</configuration>
<command>import –connect jdbc:hsqldb:file:db.hsqldb –table TT –target-dir hdfs://localhost:8020/user/tucu/foo -m 1</command>
</sqoop>
<ok to=”myotherjob”/>
<error to=”errorcleanup”/>
</action>

</workflow-app>

(or)

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

<action name=”myfirsthivejob”>
<sqoop xmlns=”uri:oozie:sqoop-action:0.2″>
<job-traker>foo:8021</job-tracker>
<name-node>bar:8020</name-node>
<arg>import</arg>
<arg>–connect</arg>
<arg>jdbc:hsqldb:file:db.hsqldb</arg>
<arg>–table</arg>
<arg>TT</arg>
<arg>–target-dir</arg>
<arg>hdfs://localhost:8020/user/tucu/foo</arg>
<arg>-m</arg>
<arg>1</arg>
</sqoop>
<ok to=”myotherjob”/>
<error to=”errorcleanup”/>
</action>

</workflow-app>

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

Subscribe
to our newsletter

Drop Us A Query

Trending Courses
  • Selenium with python
    Selenium with Python Training
  • As we know, that Selenium with Python Web Browser Selenium Automation is Gaining Popularity Day by Day. So many Frameworks and Tools Have arisen to get Services to Developers.

  • machine learning with python
    Machine Learning with Python Training
  • Over last few years, Big Data and analysis have come up, with Exponential and modified Direction of Business. That operate Python, emerged with a fast and strong Contender for going with Predictive Analysis.

  • Data science with R
    Data Science With R Training
  • Understanding and using Linear, non-linear regression Models and Classifying techniques for stats analysis. Hypothesis testing sample methods, to get business decisions.

  • data science with python
    Data Science with Python Training
  • Everyone starts Somewhere, first you learn basics of Every Scripting concept. Here you need complete Introduction to Data Science python libraries Concepts.

  • devops with azure
    Devops with Azure Training
  • As we Know Azure DevOps is a Bunch of Services, in guiding Developers. It contains CI/CD, pipelines, code Repositories, Visual Reporting Tools and more code management with version control.

  • python training
    Python Certification 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.


 

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

Call Now Button