sqoop Connecting Sqoop to other databases/datastores Import data from RDBMS to HBase table
Example
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
