Forum

This topic contains 0 replies, has 1 voice, and was last updated by  Sonali jain 2 years, 10 months ago.

Viewing 1 post (of 1 total)
  • Author
    Posts
  • #1111 Reply

    Sonali jain
    Participant

    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

Viewing 1 post (of 1 total)
Reply To: Some questions on Sqoop hope will help
Your information:




cf22

Your Name (required)

Your Email (required)

Subject

Phone No

Your Message

Cart

  • No products in the cart.