1. Install the Sqoop RPMs

  1. Install Sqoop RPMs.

    On all nodes where you plan to use the Sqoop client, install the RPMs:

    • For RHEL/CentOS:

      yum install sqoop
    • For SLES:

      zypper install sqoop

  2. Optional: Download and add database connector.

    If you plan to migrate data from HDFS/Hive/HBase to database, you must have appropriate database connector (MySQL/Oracle/PostgreSQL) JAR file.

    • For MySQL:

      1. Execute the following command on the Sqoop host machine:

        • For RHEL/CentOS:

          yum install mysql-connector-java-5.0.8-1
        • For SLES:

          zypper install mysql-connector-java-5.0.8-1
      2. Copy the JAR file to $SQOOP_HOME/lib.

        $SQOOP_HOME is by default set to /usr/lib/sqoop/.

      3. Ensure that the JAR file has appropriate permissions.

    • For Oracle: Note that the following instructions are for OJDBC driver for Oracle 11g.

      1. Download the Oracle JDBC (OJDBC) driver from here.

      2. Copy the JAR file to $SQOOP_HOME/lib.

        $SQOOP_HOME is by default set to /usr/lib/sqoop/.

      3. Ensure that the JAR file has appropriate permissions.

    • For PostgreSQL:

      1. Execute the following command on the Sqoop host machine:

        • For RHEL/CentOS:

          yum install postgresql-jdbc
        • For SLES:

          zypper install postgresql-jdbc
      2. Copy the downloaded JAR file to $SQOOP_HOME/lib directory.

        $SQOOP_HOME is by default set to /usr/lib/sqoop/.

      3. Ensure that the JAR file has appropriate permissions.


loading table of contents...