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

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
  • oracle 12c rac | OnlineITGuru
    Oracle RAC Training
  • Oracle is the large vendor in providing the various storge services to the people across the globe. This vendor provides a different amount of storage services to the people across the globe.

  • salesforce lightning training | OnlineITGuru
    Salesforce Lightning Training
  • Developing an application is not a simple and easy task. There are various parameters that the web developer need to take care while developing an application. One of those parameters that the developer needs to take care of is the code reusability.

  • 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.


 

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

Call Now Button