sqoop - Import data from RDBMS to HBase table - apache sqoop - sqoop tutorial - sqoop hadoop



Import data from RDBMS to HBase table

  • The following sqoop command will be used to import the data from RDBMS table into HBase table, if the table does not exists in HBase it will create a new table and import the data into this table
  • sqoop import \
            --query 'select emp_id, emp_name, emp_sal from employee where $CONDITIONS' \
            --connect "jdbc:sqlserver://192.168.1.99:1433;database=test_db" \
            --username username \
            -–password password \
            --hbase-create-table \
            --hbase-table employee_table \
            --hbase-row-key emp_id
    Click "Copy code" button to copy into clipboard - By wikitechy - sqoop tutorial - team

    SQOOP forum

    Sqoop Installation and Download :

    Connecting Sqoop to other databases/datastores :

  • Import data directly into Hive Warehouse
  • Import data from RDBMS to HBase table
  • Import data to new catalog
  • Import the results of a query from a relational database into HDFS
  • Load JDBC Driver
  • Sqoop Export :

  • Sqoop Export basic example
  • Sqoop Import RDBMS Table to HDFS :

  • Sqoop Import RDBMS Table to HDFS
  • Merge data-sets imported via incremental import using Sqoop :

  • Import New as well as Updated Data - lastmodified mode - Append Mode
  • Hadoop with Kite SDK :

  • Kite SDK to demonstrate copying of various file formats to Hadoop
  • Sqoop Advanced :

  • Use Sqoop to copy an Oracle table to Hadoop

  • Related Searches to Import data from RDBMS to HBase table