Hadoop Sqoop Interview Questions

Our HadoopTpoint App is now available in google play store,please rate and comment it in play store : W3Schools

Hadoop Sqoop Interview Questions

What is Hadoop sqoop ?

Hadoop sqoop is an open source and sub project of Hadoop.Hadoop sqoop is a tool that designed for efficiently transfer the huge amount of data between Apache hadoop and structure databases such as relational database management systems(RDBMS) like Sql,oracle ,MySql databases.
In other words,Hadoop sqoop is used for import and export the huge amount of data from RDBMS to HDFS and HDFS to RDBMS
RDBMS such as Mysql,oracle,sql
HDFS such as Hive,Hbase

Hadoop sqoop word came from ?
Sql + Hadoop = sqoop

What is the main use of Hadoop sqoop ?
Hadoop sqoop mainly used for import and export the huge amount of data from RDBMS to HDFS and HDFS to RDBMS

Hadoop sqoop is which type of Tool ?
Hadoop sqoop is a Data transfer tool

What is latest stable version of Hadoop sqoop ?
Latest stable version of Hadoop sqoop release is 1.4.5

What are the main methods of data transfering in Hadoop sqoop ?
Mainly two operations
i) Import
ii) Export

What is the work of Import in Hadoop sqoop ?
Import the data from RDBMS to HDFS

What is the work of Export In Hadoop sqoop ?
Export the data from HDFS to RDBMS

What is the default database for Hadoop sqoop ?
Mysql

How to install Mysql In Linux Ubuntu Operating System ?
sudo apt get install mysql server mysql client

How to Enter Into MySql prompt ?
mysql -u root -p

In the above command what -u Indicates ?
User

In the above command what root Indicates ?
Username

In the above command what -p Indicates ?
Password

How to create a Database in Mysql ?
create database databasename;

How to show all Databases names in Mysql ?
show databases;

How to use a particular database in Mysql ?
use databasename;

How to grant all databases Permissions to single user in mysql ?
Mysql> grant all privileges on databasename.* to ‘%’@’localhost';

How to grant all databases Permissions to single user in mysql ?
Mysql> grant all privileges on databasename.* to ”@’localhost';

What this ‘%’ symbol Indicates in above command ?
grant all databases Permissions to single user

What this ” symbol Indicates in above command ?
grant all databases Permissions to all users

How to create a table In Mysql ?
mysql> create table emp(empId int, eName varchar(30), eSal int);
Query OK, 0 rows affected (0.11 sec)

How to Insert the values Into the table ?
mysql> insert into emp values(111,’mahesh’, 28000);
Query OK, 1 row affected (0.00 sec)

mysql> insert into emp values(112,’neelesh’, 30000);
Query OK, 1 row affected (0.00 sec)

mysql> insert into emp values(113,’rupesh’, 26000);
Query OK, 1 row affected (0.00 sec)

mysql> insert into emp values(114,’vijay’, 26000);
Query OK, 1 row affected (0.00 sec)

How to read the entire table In Mysql ?

select * from tablename;

How to update the row in a table ?

mysql> update emp set eSal= 28000 where empId = 114;

Grant privileges to users and others ?

mysql> grant all privileges on mahesh.* to ‘%’@’localhost';
Query OK, 0 rows affected (0.06 sec)

mysql> grant all privileges on mahesh.* to ”@’localhost';
Query OK, 0 rows affected (0.00 sec)

What is Hadoop sqoop scripts standard location?
/usr/bin/Hadoop sqoop

How we can check Hadoop sqoop installed or not in a system ?
Just type the Hadoop sqoop help command
Hadoop sqoop help

What are the basic available commands in Hadoop sqoop ?
Codegen
Create-hive-table
Eval
Export
Help
Import
Import-all-tables
List-databases
List-tables
Versions

Use of Codegen command in Hadoop sqoop ?

Generate code to interact with database records

Use of Create-hive-table command in Hadoop sqoop ?

Import a table definition into Hive

Use of Eval command in Hadoop sqoop ?

Evaluate a SQL statement and display the results

Use of Export command in Hadoop sqoop ?

Export an HDFS directory to a database table

Use of Help command in Hadoop sqoop ?

List available commands

Use of Import command in Hadoop sqoop ?

Import a table from a database to HDFS

Use of Import-all-tables command in Hadoop sqoop ?

Import tables from a database to HDFS

Use of list-databases command in Hadoop sqoop ?

List available databases on a server

Use of list-tables command in Hadoop sqoop ?

List available tables in a database

Use of version command in Hadoop sqoop ?

Display version information

How to see a information about specific command in Hadoop sqoop ?

sqoop help COMMAND
sqoop help import
sqoop import –help

command aliases in Hadoop sqoop ?

sqoop-(toolname)
sqoop-import,sqoop-export

How to check List of Databases in RDBMS by using sqoop ?

root@ubuntu:/home/mahesh/sqoop-related# sqoop list-databases –connect jdbc:mysql://localhost;

13/11/07 18:55:47 INFO manager.MySQLManager: Preparing to use a MySQL streaming resultset.

O/P:-
information_schema
Gopal_Lab
NewYearDB
RK
batch18
bhargav
chandu
kelly
manoj
mahesh
sivanag

How to check List of Tables in single database by using sqoop ?

root@ubuntu:/home/mahesh/sqoop-related# sqoop list-tables –connect jdbc:mysql://localhost/mahesh;

13/11/07 18:58:21 INFO manager.MySQLManager: Preparing to use a MySQL streaming resultset.

O/P:-emp

Comments

  1. HI
    I love your site.
    I would like to know what is incremental scoop?
    Could you please add the above here?

  2. Santosh Dandin says:

    Hi,

    Sqoop Incremental Imports : where in it imports only newly added rows to HDFS ie delta part of RDBMS table.
    check-column
    last-value

    there are two modes :

    1) incremental-append : its appends the delta part.
    2) incremental-lastmodified : Time based increment

Speak Your Mind

*