How to import data to HBase from SQL server

Question

I have used Sqoop for importing data from SQL to HDFS. Does Sqoop also has the functionality of dumping data directly into HBase from SQL server?

Answer 1

You can easily import the data from SQL server to HDFS by following the below steps:

• Download the SQL Server JDBC driver on to your machine.
• Copy the JDBC driver into thelib directory present in Sqoop root directory:

cp sqljdbc.jar /usr/local/sqoop/lib

• Import the tables from SQL Server to HDFS

sqoop import --hbase-create-table --hbase-table HBase_table --column-family cf1 --hbase-row-key id --connect "jdbc:sqlserver://hostname:port;database=dbName;username=uname;password=pass" --table sql_tablename -m 1